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

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

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

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