 |
 | 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 2004Merge field using an object?
Using MS Word 2002 can you do a mail merge from an Access 2002 database where the merge field is an object containing another Word document? I'm trying to create a second page which will depend upon the query output. I've tried and the word document is NOT used as the subsequent page. So either I'm doing something wrong, or it can NOT be done. Please let me know. Thanks! Regards, Greg Strong Could you use a conditional field eg {IF {Mergefield fieldname} = "condition" "{Includetext "c:\\path\\docname.doc"}"}  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Using MS Word 2002 can you do a mail merge from an Access 2002 > database where the merge field is an object containing another Word [quoted text clipped - 8 lines] > > Greg Strong >Could you use a conditional field eg >{IF {Mergefield fieldname} = "condition" "{Includetext >"c:\\path\\docname.doc"}"} After going through the learning curve I got it to work. It will save a lot of work. Now I'll have to learn some other utility software to eliminate more work and automate the process of splitting the merged document which includes many separate documents into separate saved documents with file names included in a comment. If you have any helpful hints here it would be of great help. Thanks! Regards, Greg Strong There are several merge related tutorials on my web site, but for the immediate issue see http://www.gmayor.com/individual_merge_letters.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> >> Could you use a conditional field eg >> {IF {Mergefield fieldname} = "condition" "{Includetext [quoted text clipped - 12 lines] > > Greg Strong >There are several merge related tutorials on my web site, but for the >immediate issue see http://www.gmayor.com/individual_merge_letters.htm I will have to look into the macro, but I have other reasons learn the separate utility, PowerPro, because it can be used for other programs. I have ran into another glitch with the PowerPro script. I was using the key commands to do a lot of the work and I can't go to the 4th page of a 13 page document broken down into different sections. When I use the F5 (i.e. Go To) page 4 I end up at the end of the document because there each individual document is 3 pages long. I could have sworn it was working. Maybe in my testing the keys changed a Word setting. I don't know. Anyhow!!! Is there any setting where I can get Word to go to the 4th page with the F5 key? TIA!!! Regards, Greg Strong Goto works with Word 2003, but you can address a specific page by section/page eg s2p3 for Page three of the second letter. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> >> There are several merge related tutorials on my web site, but for the >> immediate issue see [quoted text clipped - 19 lines] > > Greg Strong >Goto works with Word 2003, but you can address a specific page by >section/page eg s2p3 for Page three of the second letter. Well this helpful hint doesn't help me a bit with Word 2002. I'll have to think of a work around. Regards, Greg Strong Have you tried addressing the required page by section and page in Word 2002? This should work for all versions. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> >> Goto works with Word 2003, but you can address a specific page by >> section/page eg s2p3 for Page three of the second letter. [quoted text clipped - 5 lines] > > Greg Strong >Have you tried addressing the required page by section and page in Word >2002? Not until just know. It works like you stated with s2p1, or what ever I need. >This should work for all versions. Yes. What really is STRANGE is I restored a bootable partition from an image. When I did the merge in the admin account I set up there were only 12 pages on the test AND all I had to do was F5 with only the number 4 to go to the 4th page. When I went to the limited account and did the merge there were 13 pages AND with F5 I had to enter s2p1 to go to the 4th page. In the limited account if I entered 4 after the F5, I would go to the last page. So something is a little fickle with Word between admin and limited users. Don't know what it is, but it definitely exists. Regards, Greg Strong >Goto works with Word 2003, but you can address a specific page by >section/page eg s2p3 for Page three of the second letter. Well Word 2002 should go to page 4 of the 13 page document. I have a multi-boot system and restored a partition with Ghost. The restored partition with Word 2002 did work the way I thought it should. Simply stated something messed up my system. Regards, Greg Strong >There are several merge related tutorials on my web site, but for the >immediate issue see http://www.gmayor.com/individual_merge_letters.htm Between your link above and the additional two below: http://www.cpearson.com/excel/clipboar.htm http://support.microsoft.com/?kbid=212730 I was able to pull the data off the merged document, copy it to the clipboard, and use for the file name. The file name provides a direct link to the data in the Access database. I had to use the 'DataObject' in order to do this which reguired a reference to the Microsoft Forms 2.0 object library. The last link above tell you how to set up the reference. Works like a charm. THANKS!!! ,----- [ Modified splitter ] | Sub Splitter() | ' splitter Macro [quoted text clipped - 48 lines] | | End Sub `----- Regards, Greg Strong No, Word mailmerge cannot extract the content of an Access object field in that way. You have to export the contained document to the file system first then use an INCLUDETEXT. -- Peter Jamieson - Word MVP > Using MS Word 2002 can you do a mail merge from an Access 2002 database > where the merge field is an object containing another Word document? [quoted text clipped - 7 lines] > > Greg Strong
|
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.