Excel to Word email merge- need help consolidating data

Let me understand what you are trying to do here. You want to give each location a database that they can use to generate individual letters for employees at their sites?

If this is the case, then each site will get an excel file with a list of their employees only (and what other information might have to "tag along") and they can all use the same Mail Template. About the only issue they would have to deal with is to connect the template to the source but if they save the excel file in the same place with the same name every time, this is a one-time event.

We can set this up, but I'll have to see some sample data:




Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.