I need to create personalized letters which are then emailed to corresponding email addresses. It seems this would need to be a script using Excel as a data source, Word and Outlook. I cannot find this functionality in the programs. Has anyone seen something like this? Are there any other solutions such as an Access database perhaps?
Thank you for information on how to create mail merge documents. I want to use mail merge to create the personalized document and then automatically email them as attachments to the individual emails associated with each name in my data file. This does not appear to be possible with the mail merge module in word or am I missing it?