Excel 97 - Can it link with Outlook to do Email Merging?

[mattpearcey]

I have an Access Database in which i have a field named ContactPersonEmail, and i would like to send a common email to all of those contact persons, with captured email addresses. There are 93 records where this is the case. I dont want to have to send the email 93 times, by copying and pasting the email address into 93 seperate emails. Is there a way thsi can be done automatically? either through access or by outputting this data into a report and then into excel? I think that Excel would be a better option, but as i say, i have not heard of this done before. I do not know MS Exchange at all, but would like some information as to how this can be done through outlook? If anyone does have any info?

Does anyone have any experience with this or would know a better way in which it can be done? Thank you for your help already.

Matt Pearcey

 

[Dreamboat]

Hi Matt.

IMHO, the easiest way for you to do this is to create a new Contacts folder called "MyMerge" or something like that. COPY the 93 people into that folder.

Do your mailmerge and choose Address book as the data source.

If that doesnt' work, and it doesn't always work because of the way things are set up, then export that new folder to an Excel file. In the Excel file, delete all the columns you don't need (You don't HAVE to do this). Merge to the Excel file.

Check here too:

http://www.mvps.org/word/FAQs/Mailmerge.htm

techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word