Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2017, 11:48 AM
iv_tavares iv_tavares is offline Copy and Paste mailmerge data sources in bulk Windows 10 Copy and Paste mailmerge data sources in bulk Office 2016
Novice
Copy and Paste mailmerge data sources in bulk
 
Join Date: May 2017
Posts: 1
iv_tavares is on a distinguished road
Default Copy and Paste mailmerge data sources in bulk


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?
Reply With Quote
  #2  
Old 05-18-2017, 03:28 PM
macropod's Avatar
macropod macropod is offline Copy and Paste mailmerge data sources in bulk Windows 7 64bit Copy and Paste mailmerge data sources in bulk Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Without knowing precisely what you're changing, it's impossible to know how to resolve the matter. From your post I can't tell, for example, whether you're changing the data source, the mailmerge main document, or the mailmerge output document. Changing some content in any of these would neither stop it being nor make it your mailmerge source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-18-2017, 06:25 PM
eduzs eduzs is offline Copy and Paste mailmerge data sources in bulk Windows 10 Copy and Paste mailmerge data sources in bulk Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

Quote:
Originally Posted by iv_tavares View Post
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.
Reply With Quote
  #4  
Old 05-18-2017, 06:28 PM
macropod's Avatar
macropod macropod is offline Copy and Paste mailmerge data sources in bulk Windows 7 64bit Copy and Paste mailmerge data sources in bulk Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by eduzs View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
bulk copy paste, mail merge, vba macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste mailmerge data sources in bulk 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
Copy and Paste mailmerge data sources in bulk 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft