Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print 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. |
#2
|
|||
|
|||
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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#3
|
|||
|
|||
I was afraid of that. Thank you for your help, and I apologize for
misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#4
|
|||
|
|||
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 "Jim" wrote in message ... I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#5
|
|||
|
|||
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 "Jim" wrote in message ... I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#6
|
|||
|
|||
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 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mike wrote: 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 "Jim" wrote in message ... I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#7
|
|||
|
|||
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 "Graham Mayor" wrote in message ... 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 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mike wrote: 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 "Jim" wrote in message ... I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
#8
|
|||
|
|||
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 "Mike" wrote: 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 "Graham Mayor" wrote in message ... 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 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mike wrote: 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 "Jim" wrote in message ... I was afraid of that. Thank you for your help, and I apologize for misspelling envelope. "Graham Mayor" wrote: 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). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jim wrote: 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you use mail merge on a protected document? | Mailmerge | |||
Mail Merge DOcument Size Limit | Mailmerge | |||
How do I print mailing labels with mail merge? | Mailmerge | |||
How can you print all documents in a mail merge? | Mailmerge | |||
How do I mail merge when only merge document is shown in tools? | Microsoft Word Help |