Excel columns to email address

May 2, 2005 at 20:11:17
Specs: XP Pro / Fedora 3, Athlon 64 3500+/1Gb Corsa

Not really sure if this can bve done or not but i have a list of people in our organization in an excel spreadsheet in the form of:

| Survey | USERID | First | Last |

We have recently run an internal IT survey and i put an asterix in the survey column when the person has completed this.

Now, i need to send an email to every person that hasn't completed it. Using outlook we have a complete contact book so to send an email to multiple people you use the format:

TO: lastname firstname; lastname firstname etc

So what i need to do is either extract the data from the two colums, format it to:

lastname firstname; etc

or find away to do it through excel.

Any ideas before i have to send around 800 emails by hand?

Thanks
-Matt


Gigabyte K8NSNXP-939
Athlon 64 3500+ @2450
Dual -
Corsair TwinX CMX512-3200XL
Gecube X800 XT Platinum
Seagate 200 Gig
Coolermaster Wavemaster Silver


See More: Excel columns to email address

Report •


#1
May 3, 2005 at 03:26:31

I just tried it and found it works just fine.

Sort your names using the asterik column to segregate the names you need in your email.

Lets say your firstname and lastname are in A1 and B1.
In C1 use =CONCATENATE(B1&" "&A1&;)
That's B1(lastname) followed by a space and C1(firstname) followed by a semi-colon.
Drag it down your column.

Select column C.
Right click on Column C and select Copy.
Right click on column C and select Paste Special, Data.

Click on C1, hold down the Shift key and hit the Down Arrow key to select all the cells in column C with your formatted names. Right click and select Copy.

Open your mail message and click into the To: field.
Hit Ctrl+V to Paste all of your names. (It looks messy at this point)

Hit the Check Names button (or Tools, Check Names) to bring them all into your message.

Hope this works as smoothly for you,
Bryan


Report •

#2
May 3, 2005 at 03:52:15

Oh man your a genius!!

I didn't even think of doing it that way, you may have just saved me a couple of days worth of work!!

Thanks Again!!

BTW, this is the first thing i have done using the PC on my new 48 Inch LCD TV, man it looks good :) BRAG BRAG BRAG

Your a legend
-Matt

Gigabyte K8NSNXP-939
Athlon 64 3500+ @2450
Dual -
Corsair TwinX CMX512-3200XL
Gecube X800 XT Platinum
Seagate 200 Gig
Coolermaster Wavemaster Silver


Report •

#3
May 3, 2005 at 16:27:30

Man you are a legend, just did it first thing this morning! Saved me hours of work "concatenate" is the king of all functions!!!! heh heh

Wooooo hoooo

-Matt

Gigabyte K8NSNXP-939
Athlon 64 3500+ @2450
Dual -
Corsair TwinX CMX512-3200XL
Gecube X800 XT Platinum
Seagate 200 Gig
Coolermaster Wavemaster Silver


Report •

Related Solutions


Ask Question