 |
 | 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 / July 2006Save 2,400 letters saved from merge document
When I try to retrieve the 2,400 letters generated from the merge form after the initial merge and saving it to a new file name, I can only view one letter of the 2,400. It always asks me: "Opening the document will run the following SQL command. Slect from "name of file". Data from your database will be place in the doument. Do you want to continue?" If I say yes or no only the last letter I viewed when originally merging shows. How can I view all 2,400 letters without linking it back to the data base? I need to print, view, and/or edit individual letters as needed; without linking it to the original data base. As always thanks..........  Signaturecat You receive the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source - http://support.microsoft.com/?kbid=825765 If you want to selectively view and print from yourmerge, merge to a new document. See also http://www.gmayor.com/individual_merge_letters.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When I try to retrieve the 2,400 letters generated from the merge > form after the initial merge and saving it to a new file name, I can [quoted text clipped - 6 lines] > and/or edit individual letters as needed; without linking it to the > original data base. As always thanks.......... That message indicates that you have not executed the mailmerge. You must execute the merge to a new document. It is that document that will contain the 2400 letters. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > When I try to retrieve the 2,400 letters generated from the merge form > after [quoted text clipped - 10 lines] > view, and/or edit individual letters as needed; without linking it to the > original data base. As always thanks.......... How does one "execute the merge to a new document"? Thanks, Frank > That message indicates that you have not executed the mailmerge. You must > execute the merge to a new document. It is that document that will contain [quoted text clipped - 14 lines] > > view, and/or edit individual letters as needed; without linking it to the > > original data base. As always thanks.......... Display the Mail Merge toolbar by selecting Toolbars from the View menu and then check the Mail Merge item. On the right hand end of the toolbar there are buttons for executing the merge to the various destinations. See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > How does one "execute the merge to a new document"? > Thanks, [quoted text clipped - 23 lines] >> > the >> > original data base. As always thanks.......... |
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.