Forum Discussion

Liam686's avatar
Liam686
Copper Contributor
Jan 22, 2020

Keeping Fields in Mail Merge

Hi Guys, 

 

New to the site so hi!

 

I am currently out of ideas on the following problem.

 

I have a spreadsheet with around 550 records in it which are subject to a fairly regular update from a client. I need to create a word document for each of these records that will be stored on SharePoint so that we can input our own information.

 

I have already created a reference document on the network so that references to the main spreadsheet so the mailmerge field to an HTTP document is not required.

 

So far I have managed to mail merge these records and split them into the required word documents using the add on from Graham Mayor (merge and split), however this replaces the fields with actual text following merging and splitting. Its driving me crazy. 

 

Im not sure even if this is possible without doing manually (could take weeks), or if there is a way to make VBA do the same job as the mail merge but keep the fields. I am trying to merge around 12-13 fields.

 

Thanks

 

Liam

No RepliesBe the first to reply

Resources