Reply
 
Thread Tools Display Modes
  #1   Report Post  
Bill Meyer via OfficeKB.com
 
Posts: n/a
Default labels on 11x17 for mail merge??

Is it possible to set up labels for mail merge on 11x17 paper. I know how
to create a custom label and all, I just can't find a way to go larger than
8.5x11.

anyone??

BILL

--
Message posted via http://www.officekb.com
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

You are right that the available page sizes is restricted. This is reflected
in VBA by the fact that there is a fixed set of page size constants, and
unfortunately, as usual in this kind of scenario, no facility to let you
define anything else.

What I think you will have to do is create a document with the correct paper
size, then create your own table layout with one cell for each label,
adjusting the various cell properties as required in Table|Table Properties
etc. Then put a { NEXT } field in every cell except the first. Then proceed
as usual. A test here suggests that that will work.

Instead, you could try starting with a custom layout on a "supported" paper
size, then change the paper size and create new columns and rows. However,
what I found when I did this was that the proagate labels function put
copies of the first label in every table cell, not just the cells intended
to contain label data, which means the output will look as if every other
label has been skipped. However, it is possible that I did something wrong
when I did this and that there is a way to make it work as you might hope.

Peter Jamieson
"Bill Meyer via OfficeKB.com" wrote in message
...
Is it possible to set up labels for mail merge on 11x17 paper. I know how
to create a custom label and all, I just can't find a way to go larger
than
8.5x11.

anyone??

BILL

--
Message posted via http://www.officekb.com



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
30 page mail merge labels only prints one page? bdhamer Mailmerge 2 October 13th 05 05:07 AM
How do I print mailing labels with mail merge? DanaTunstall Mailmerge 5 February 13th 05 10:09 PM
Word Labels into Mail Merge Labels GG Katie Mailmerge 1 January 25th 05 12:12 AM
Mail merge using labels and tables DanaHuffman Mailmerge 2 December 28th 04 08:42 AM
Why can't I use Mail Merge Wizard with Avery 2160 labels?. Andy39 Mailmerge 1 December 10th 04 03:19 AM


All times are GMT +1. The time now is 12:10 AM.

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"