Outlook 2007 Mail Merge multiple emails

[Dr. Hackenbush]

Hello would like some advice/help please

I am using Outlook 2007 , Excel 2007, Word 2007.

I have a spreadsheet that i use to keep around 300 records on a clubs
membership. I would like to send them their renewal/update letters via
Email.
Before I was aware that Outlook had a Mail Merge facility I had already
prepared the letters using Word 2007 and Mail Merge.

Can this be done in Outlook, ie; send out 300 individual Emails with each
members own details merged from Excel on the Email, but with me only
actually producing one master template with multiple fields linked to a data
source(Excel), like i have done in Word ?

So far, I have imported all the Email addresses from each members record in
Excel, into Outlooks Contacts and made a distribution list

Now, using that Distribution list how do I produce an individual Email to
each of the addresses on that list with merged data.

I have looked for some tutorials on Google but not seen anything that seems
to do what i want. Maybe i have missed something obvious here or maybe it
cant be done, either way i have reached a mental impasse !

Hope this all makes sense if not i can provide more info

I am open to all offers of advice,suggestions, workarounds etc !

I'm off to work now so wont be able to check back here until tonite, but
thanks for your time in advance

Cheers'n'Beers

 

[Russ Valentine [MVP-Outlook]]

You can use either Outlook Contacts or your Excel spreadsheet as the
datasource for a mail merge. You cannot use a DL. Help files will answer all
your questions.

 

[Dr. Hackenbush]

Ok , got there in the end. I actually found the help slightlyconfusing in
this instance.

It was actually easier than i thought, it was staring me in the face D'oh. I
spent more time thinking about what to do instead of actually going ahead
and doing it, live and learn !

Thanks for replying

You can use either Outlook Contacts or your Excel spreadsheet as the
datasource for a mail merge. You cannot use a DL. Help files will answer
all your questions.
--
Russ Valentine
[MVP-Outlook]

Hello would like some advice/help please

I am using Outlook 2007 , Excel 2007, Word 2007.

I have a spreadsheet that i use to keep around 300 records on a clubs
membership. I would like to send them their renewal/update letters via
Email.
Before I was aware that Outlook had a Mail Merge facility I had already
prepared the letters using Word 2007 and Mail Merge.

Can this be done in Outlook, ie; send out 300 individual Emails with each
members own details merged from Excel on the Email, but with me only
actually producing one master template with multiple fields linked to a
data source(Excel), like i have done in Word ?

So far, I have imported all the Email addresses from each members record
in Excel, into Outlooks Contacts and made a distribution list

Now, using that Distribution list how do I produce an individual Email
to each of the addresses on that list with merged data.

I have looked for some tutorials on Google but not seen anything that
seems to do what i want. Maybe i have missed something obvious here or
maybe it cant be done, either way i have reached a mental impasse !

Hope this all makes sense if not i can provide more info

I am open to all offers of advice,suggestions, workarounds etc !

I'm off to work now so wont be able to check back here until tonite, but
thanks for your time in advance

Cheers'n'Beers