Is there a way to do a mail merge type of addition of data after a mail merge has been done?

mtandino · #1 05-24-2021, 08:14 AM

So I have a document and about 200 users that I need to create separate documents on using mail merge. I have done the mail merge and added information that could not be added using mail merge to each users' document manually. The issue is, I will be receiving another batch of information in Excel that needs to be added to each users' document which could be added via mail merge but I have already done it and the manual work that is quite tedious.

Is there anyway to merge this new information in Excel with each users' document now?

macropod · #2 05-24-2021, 03:53 PM

You should add the 'added information' to the data source so that it doesn't need to be manually added post-merge. Then, when you get 'another batch of information in Excel', you can re-run the merge and incorporate all the data into the new output documents.

mtandino · #3 06-01-2021, 07:11 AM

Quote:

Originally Posted by macropod

You should add the 'added information' to the data source so that it doesn't need to be manually added post-merge. Then, when you get 'another batch of information in Excel', you can re-run the merge and incorporate all the data into the new output documents.

That's the thing, the information that I am adding, pictures, cannot be added using mail merge otherwise I cannot share the file with other users. I agree that I should have added the 2nd batch of information with the 1st batch but I have already manually added the pictures so I am wondering if there is a way to add this second batch of data now, unless I am misunderstanding you.

macropod · #4 06-01-2021, 02:00 PM

Quote:

Originally Posted by mtandino

That's the thing, the information that I am adding, pictures, cannot be added using mail merge

That simply isn't true. See Managing Mailmerge Graphics on the Mailmerge Tips and Tricks page: https://www.msofficeforums.com/mail-...ps-tricks.html

Charles Kenyon · #5 06-01-2021, 10:31 AM

Mail merge graphics by Graham Mayor, MVP

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file	sureshbvs	Word VBA	1	03-12-2021 05:42 AM
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge	djrexy	Mail Merge	1	05-20-2020 04:04 PM
Mail merge type fields in publisher	TerryTunesmith	Publisher	1	02-12-2020 08:14 PM
Mail Merge Document Type	craigj	Mail Merge	2	10-03-2016 08:39 PM
Is data merge and mail merge the same thing?	ikearns	Mail Merge	1	09-12-2014 03:53 AM