 |
 | 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 / June 2005Print envelops from a mail merge document
I have created a mail merge form letter document in Word 2003 that selects recipients from an Access 2003 database using a query. I would to print evnelops to the recipients, which is based on the form letters, which has the name and address' placed in the Address Block. I am trying not to create another mail merge document for envelops, which will use the same query and the form letter. Thanks in advance. Attempting to merge letters with envelopes together imposes some interesting demands on the abilities of your printer and is frankly impractical in most circumstances. It is a simple matter to create an envelope merge and use the same data source and that is what I would recommend. You can even use the envelope templates for download from my web site as a start point (though you will have to unlink the macros they contain).  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have created a mail merge form letter document in Word 2003 that > selects recipients from an Access 2003 database using a query. I > would to print envelopes to the recipients, which is based on the form > letters, which has the name and address' placed in the Address Block. > I am trying not to create another mail merge document for envelops, > which will use the same query and the form letter. Thanks in advance. I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. > Attempting to merge letters with envelopes together imposes some interesting > demands on the abilities of your printer and is frankly impractical in most [quoted text clipped - 9 lines] > > I am trying not to create another mail merge document for envelops, > > which will use the same query and the form letter. Thanks in advance. Jim, I *think* I have a way to do this - I had a similar question at work. It involves using section breaks and adjusting the page settings - let me check to see how it works with a mail merge. Mike > I was afraid of that. Thank you for your help, and I apologize for > misspelling envelope. [quoted text clipped - 12 lines] > > > I am trying not to create another mail merge document for envelops, > > > which will use the same query and the form letter. Thanks in advance. Okay...it works! Create a blank document, then insert a section break (next page). On the second page (your envelope), go to file, page setup and and format the margins & paper for an envelope (make the margins smaller, etc.). Make sure to select "This section" when you change the page formatting. Then create the mailing address for the envelope - Word's envelope tool uses a frame, but I find it easier to use a single cell table (turn off the borders). The advantage of this - in case people are wondering why go to all this trouble - is the letters & envelopes will be all next to each other. Mike > I was afraid of that. Thank you for your help, and I apologize for > misspelling envelope. [quoted text clipped - 12 lines] > > > I am trying not to create another mail merge document for envelops, > > > which will use the same query and the form letter. Thanks in advance. That's all very well if your printer has separate bins for envelopes and letters - and even then some printer drivers will conspire against you, but when it works, it works :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Okay...it works! Create a blank document, then insert a section > break (next page). On the second page (your envelope), go to file, [quoted text clipped - 36 lines] >>>> document for envelops, which will use the same query and the form >>>> letter. Thanks in advance. Many laser printers have a multi purpose or separate manual feed tray that can hold multiple envelopes (eg, the Lexmark T630 can hold 10 without the envelope feeder). However, I agree this setup would not work if you don't have a separate way to feed envelopes - otherwise you're going to be standing by the printer for a loooong time ;). Mike > That's all very well if your printer has separate bins for envelopes and > letters - and even then some printer drivers will conspire against you, but [quoted text clipped - 40 lines] > >>>> document for envelops, which will use the same query and the form > >>>> letter. Thanks in advance. I, too, have had to deal with this. Here's a workaround that works for me: I have a main merge document that includes the envelope and letter. Luckily each letter is only one page and our printer has an envelope feeder. Anywho, after the merge is completed, you see envelope, letter, envelope, letter, etc. separated by section breaks. I then select Control+P, and select "Odd Pages" in the Print dialog box to print all of the envelopes. I then do Control+P again and select "Even Pages", which prints all of the one page letters on letterhead. It ain't pretty, but it works :) > Many laser printers have a multi purpose or separate manual feed tray that > can hold multiple envelopes (eg, the Lexmark T630 can hold 10 without the [quoted text clipped - 49 lines] > > >>>> document for envelops, which will use the same query and the form > > >>>> letter. 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.