TOPIC:

Hi Folks,

Can anyone help at all?

I've got a rather long list of people I need to send the same email to. So, rather than having to do it one at a time, I believe it's possible to have a list on excel and do a mail merge with outlook.

Does anyone who if this is possible, and if so where I can learn how to do it?

Many thanks

Rockape

Hey Rockape,

this article could be helpfull
support.microsoft.com/kb/295664/en-us

another way could be to create a "form letter" (is this the correct word?) with MSword and insert the Adresses via Excel list.

let me hear your thoughts / replies on this...


-chrnxR

Thanks chrnxR,

A month back I was searching something like that only. Hope I remember the process next time I need it.

Regards.

First import the contacts from the excel file:

support.microsoft.com/kb/295664


THEN:

First, Select your Contacts. Second, go to Tools, and select Mail Merge.
In the Mail Merge Contacts window choose:
Only selected contacts
All contact fields
If you have your newsletter handy, choose Existing document and then use the Browse button to select it.

In the Merge options section, choose Form Letters as the Document type and Email as the Merge to selection.
Type in the subject of your message when the Message subject line text box appears.

Now click the OK button (CREDIT:https://www.realtown.com/larry2/groups/all-things-outlook/view/10308)



Your other option if you want to personalize it and you have a TON of emails to run down is to create a custom AutoHotkey Script to Personalize each email. (not recommended but fun to watch)

Cheers guys,

I'll give it a try when I can find some free time