Feeding a Word Document from Excel Source (not a mail merge)

macropod · #3 09-30-2022, 08:03 AM

Quote:

Originally Posted by Jen75

I've researched mail merging, but this is different because I'm starting with an existing document and not a blank template. Recreating this as a blank template in order to use a mail merge is not an option.

Unless the content of all those letters differ, all you need for a mailmerge is to delete delete all except the first letter then, using a standard 'letter' mailmerge, connect to your Excel datasource and replace whoever's name you have there with a mergefield pointing to the relevant column header.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Customize document content based on Mail Merge source fields?	mallorious	Mail Merge	5	09-22-2020 03:04 PM
Creating a table in one document of WORD from EXCEL with Mail Merge	Joseph.Comerford@bentley.	Mail Merge	1	04-18-2015 01:19 AM
Merge fields in Word and source data from Excel	SteveVai	Mail Merge	3	03-13-2014 05:25 AM
Data from hidden internal tables feeding listboxes in same Word Document	marksm33	Word VBA	2	02-21-2014 07:10 PM
Mail Merge using Word 2010 - Header source not be recognized	Gage262	Word	8	02-01-2012 11:08 AM