Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
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 |