Can you do a mail merge from multiple data sources?

Question

Out of the box, mail merge can only use a single, flat data source. Therefore, you would either need to combine all of your data onto the one worksheet, or create a "roll-your-own" VBA based equivalent to mail merge that had the necessary logic included in it to know how to handle your multiple sources of data. 8 сент. 2010 г.

How do you combine data from different data sources?

Merging Data from Multiple Sources1Download all data from each source. ... 2Combine all data sources into one list. ... 3Identify duplicates. ... 4Merge duplicates by identifying the surviving record. ... 5Verify and validate all fields. ... 6Standardize the data.How to Merge Data from Multiple Sources into a Single Platform

How do I do a mail merge with multiple records on one page?

How to set up a merge document to include multiple records on one...1In the simple mail merge, insert all of the desired Raiser's Edge 7 merge fields, using the 'Insert Raiser's Edge field' button located at the top of the Word document. ... 2Insert the RE7 merge fields again, then repeat steps 1-2.How to set up a merge document to include multiple records on one page

How do you do multiple mail merge in Word?

To insert a merge field, select the Mailings tab, click Insert Merge Field, then choose your merge field. Repeat the steps to populate your document with the appropriate merge fields. When complete, save your letter; this will be called the Form Letter.

How do I do a mass mail merge?

Go to Mailings > Insert Merge Field, and then choose the fields to add. In your main document, select Drag fields into this box or type text, and click or tap the text to remove it. Add and format the fields you want to be included in the email message, and choose OK.

Expert · Answer