How do I email a .pdf attachment through a mail merge Word & Outlook 2010

If the client will only accept one invoice per email, you are going to need to create a separate pdf for each invoice.  Then you could use the Merge with Attachments facility on my MergeTools Add-in to send multiple emails to the client, each one with an invoice attached and with an individualised subject line if you have a data source with multiple records for the client, but with each record having the path\filename of a unique attachment and unique text in the field that you select as the Subject field when using the add-in.

I have an unique scenario in that I have to email the same email address repeatedly with a pdf attachment, however the attachment is different each time, as is the email message AND subject line.  I have a client that I send 300-500 invoices to each month, so the recipient email is always the same, however each attachment is one invoice (they will not accept more than one per email.) and I have to state descriptive information in the subject line.  Would your add-on be able to assist in automating this so I do not have to spend a whole day sending 400 emails to the same email address?  Currently the invoices are all in one pdf, but can be broken out into several if required.

This is so helpful! Thank you very much.

You can do that with the MergeTools – 20140218.dotm Add-in that I created that you can download from the following page of my One Drive:

http://bit.ly/1hduSCB

The file needs to be saved in the Word Startup folder.  In Windows XP the default location for that folder is

C:\Documents and Settings[User Name]\Application Data\Microsoft\Word\STARTUP

In Windows Vista and Windows 7, 8 or 8.1 it is

C:\Users[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

When that has been done and Word is started\re-started, the tab shown below will be added to the Ribbon:

One thing to note is that the field names in the data source must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9).

You may also want to download:

1. the Merging with Attachments document that is also on that page which explains how the system is used.  It is not actually necessary to have separate attachments as the facility can be used to send just the documents created by the merge itself as attachments, either as the body of the message itself or in the form of Word files or .pdf files.
2. the Mail Merging with Charts document that is also on that page.  That document explains how you must set up the Excel Data Source and the Mail Merge Main document to be able to execute a merge with a Chart that is unique to each record in the data source.
3. the Using the Many to One Facility document that describes how to use that facility.