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
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
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
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