Hi there,



I'm currently running what is in effect a monthly Speed Dating project, but for business purposes (!). The matches are created through an Excel spreadsheet which will generate c75 pairings each month which are sent out to a mass distribution list. Given the numbers involved, it can be a lengthy email and isn't very user-friendly.

What I'm looking to do is to be able to email a set email template to each pairing, however, ideally would automate this rather than 75 separate emails. Is this something that can be done through a mail merge?

As far as I know, the built-in email merge is very limited, where you can only send to one recipient at a time. So you'd have to put your 'pairs' actually on separate rows, and they'd get separate emails. Your actual template would be done in Word, and you then load your data in there, add the merge fields from your data, and then send the email merge through Word; FYI it will only send from your default Outlook email account. Hope this gives you some direction

You may be able to use E-Mail Merge Add-in to create your e-mail messages configured in a Word document.

If the data comprises consecutive pairs of records, you may be able to use Merge Many To One to create a many to one merge to e-mail.

All depends on how the data is configured.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com