Copy and Paste mailmerge data sources in bulk

eduzs · #1 05-18-2017, 06:25 PM

Quote:

Originally Posted by iv_tavares

I have a document that I need to apply a mail merge on it. The problem is, my document has 67 pages, and I need to change one name that appears 510 times making it my source to the mail merge. When I try to modify that name all at once, the mail merge doesn't work. Is there any VBA code that can fix this?

If you change the value of the variable to see the modification you just need to select all you document and press F9.

macropod · #2 05-18-2017, 06:28 PM

Quote:

Originally Posted by eduzs

If you change the value of the variable to see the modification you just need to select all you document and press F9.

That has nothing to do with whether the mailmerge would continue to work. Furthermore, if the modification was being made to a mergefield's display value, updating the document would simply erase the change.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why does PPT reformat my data when I copy & paste to another file?	Maxwellmorlay	PowerPoint	1	04-09-2017 03:22 AM
Want to change Macro to copy and paste data to new sheet	Vortex69	Excel Programming	0	12-23-2014 09:53 PM
Cannot copy ->paste table structure but data pastes ok	kangz	Word	1	04-24-2012 04:05 AM
Losing Text box data when copy and paste	Spay	Excel	0	03-15-2011 07:18 AM
How would I bulk select and copy highlights and then bulk paste them automatically?	copywriterpro	Word	0	04-19-2010 05:21 AM