Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2018, 02:33 PM
macropod's Avatar
macropod macropod is offline Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Windows 7 64bit Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

If the mergefield is still in the header after your code has run, that's because you're still not executing the merge.



You really do seem determined to do things your own way instead of following the advice given...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-17-2018, 03:08 PM
RMerckling RMerckling is offline Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Windows 7 64bit Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Office 2010 32bit
Novice
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA
 
Join Date: Jan 2018
Posts: 29
RMerckling is on a distinguished road
Default

Paul, last time I executed the merge, I was stuck with a nasty error that wouldn't go away. My process & code works (with the exception of the footer that doesn't get unlinked with the rest of the mergefields).

Considering I have these workbooks/documents in front of me, which are complex and difficult to explain sometimes, it may be most beneficial to try and find a solution for what I'm asking, although please do not get me wrong, I do appreciate your attempts to modify the entire process and give me a more straightforward approach.

Fact is, I put a lot of time into this method and I don't have the time to re-start, re-test, and re-train individuals when a process is working effectively (compared to previous processes). All I need now is this footer to unlink so when my users send their Word Docs to PDFs or go to print the Doc, the footer doesn't change to a mergefield. Aside from that, the process is great and I'd like to continue using it.

With all that being said, if you don't have a solution, that's fine and again, I appreciate your time & efforts.
Reply With Quote
Reply

Tags
excel vba, mail merge, word vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Mail Merge a Listing grouped by specific field KarenLS Mail Merge 1 11-11-2012 02:41 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Mail Merge: cannot display the field in Excel correctly derricklo1980 Mail Merge 5 08-16-2012 07:15 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA Mail Merge: cannot display the field in Excel correctly derricklo1980 Excel 1 08-16-2012 12:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:35 AM.


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