 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2005Mail Merge Field Stripping
Hello all. Is it possible to save a copy of a word document that is stripped of all mail merge fields? I found the "Main document setup" button on the mail merge toolbar, and checked the radio button "Normal Word Document" (what a co-worker told me to do), and that makes it impossible to switch to the next/previous record, but the text that was inserted is still a field. Is there another way? Perhaps with VBA to do this? Or am I missing something completely obvious here? Thanks in advance. You want to strip the merge documents of fields ie a normal document, as you have been told, but you still want the data from the individual records (the fields) available? This doesn't make any sense. What you may require is to actually perform the merge to a new document?  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello all. Is it possible to save a copy of a word document that is > stripped of all mail merge fields? I found the "Main document setup" [quoted text clipped - 4 lines] > Perhaps with VBA to do this? Or am I missing something completely > obvious here? Thanks in advance. No, you got that backwards. What I want is just a normal document (what's showing where there are fields should no longer be fields, but just text). However, when I convert it to a "normal document", it is still referencing the excel file (I get a popup asking me if I want to "connect and SQL datasource" or something to that effect...by the way, how do you get rid of this popup?). But inside the file, the mail merge buttons are grayed out, so it doesn't make sense. Hope this helps explain it. > You want to strip the merge documents of fields ie a normal document, as you > have been told, but you still want the data from the individual records (the [quoted text clipped - 17 lines] > > Perhaps with VBA to do this? Or am I missing something completely > > obvious here? Thanks in advance. I can't reproduce this. If the document type is changed from a merge document to a normal word document then saved and closed, it becomes detached from its data file and so the pop-up doesn't appear when the document is re-opened. You can convert the fields to text with CTRL+A then CTRL+SHIFT+F9 Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > No, you got that backwards. What I want is just a normal document > (what's showing where there are fields should no longer be fields, [quoted text clipped - 28 lines] >>> Perhaps with VBA to do this? Or am I missing something completely >>> obvious here? Thanks in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.