Email & Excel

Hello

Say I needed to send an email to ~ 1,000 people. The email is the same for everybody except for three values: email address, full name, and document number.

So the email body will say:

*Hello, [full name]

Blah blah [document number] blah blah*

These unique values are stored in an Excel spreadsheet.

Instead of having to manually cut-n-paste these values into 1,000 seperate emails, is there any way to automate the process, like with a macro or something?

IT gurus, how would you handle this task?

Thanks

Email client = Outlook 2003, SP-1
Excel 2003, SP-1

You may need to be using Word as your email editor to get this to work, but it looks pretty straightforward. Under tools, mail merge, you have the option to select email as the document type.

Whoa, I never knew about the ‘Mail Merge’ functionality of Word! After briefly checking it out, it looks like it might work!

Awesome, thanks Harriet!

:smiley: