Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jim
 
Posts: n/a
Default 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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Jim
 
Posts: n/a
Default

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   Report Post  
Mike
 
Posts: n/a
Default

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   Report Post  
Mike
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Mike
 
Posts: n/a
Default

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   Report Post  
TS in FL
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you use mail merge on a protected document? anstoker Mailmerge 4 July 6th 05 05:12 PM
Mail Merge DOcument Size Limit Lea B Mailmerge 0 February 18th 05 06:59 PM
How do I print mailing labels with mail merge? DanaTunstall Mailmerge 5 February 13th 05 10:09 PM
How can you print all documents in a mail merge? BLJ Mailmerge 1 December 9th 04 06:16 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 04:45 PM


All times are GMT +1. The time now is 12:57 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"