Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-28-2020, 09:35 PM
AghkTi AghkTi is offline Prompt the alert when reuse the merged document Windows 10 Prompt the alert when reuse the merged document Office 2010
Novice
Prompt the alert when reuse the merged document
 
Join Date: Sep 2020
Posts: 1
AghkTi is on a distinguished road
Default Prompt the alert when reuse the merged document


Why Words does not prompt the alert "Opening this document will run the .....database" when reuse the merged document? As a result, updates in Excel can't be shown in Words accordingly.
Reply With Quote
  #2  
Old 09-28-2020, 11:17 PM
gmayor's Avatar
gmayor gmayor is offline Prompt the alert when reuse the merged document Windows 10 Prompt the alert when reuse the merged document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Is this the message. If so see the last item at Word VBA examples



__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-30-2020, 02:30 PM
Charles Kenyon Charles Kenyon is offline Prompt the alert when reuse the merged document Windows 10 Prompt the alert when reuse the merged document Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

This would indicate that you have not completed the merge. A fully merged document will no longer have connection to the data but be a document, rather than a primary merge document.

I usually do not complete merges but rather use the preview for a particular record and save / print it. If so, when I close and reopen I get that message. I have a macro I use which converts it to a non-merge document and locks the merge fields to retain current data. I have another that unlocks those fields, makes it a letter merge document, and then reattaches the data for those rare cases where I need to do that.

I should note that my method of using mail merge is considered heretical, or at least non-standard.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically prompt for document properties on first save of a document? dsv Word 2 10-05-2019 11:02 AM
Prompt the alert when reuse the merged document Help with Document Properties Prompt Macro KJJ Word VBA 14 11-10-2016 08:18 PM
Prompt the alert when reuse the merged document How to dismiss/avoid warning/alert dialog boxes in Microsoft.Office.Interop.Word.Document meenagrace Word VBA 3 11-07-2014 01:29 PM
Prompt when close the document ubns Word 15 04-29-2012 10:07 PM
Prompt the alert when reuse the merged document Prompt for Selection Point in document caddcop Word VBA 3 06-14-2011 05:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:30 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