Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

labels on 11x17 for mail merge??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Meyer - 07 Mar 2005 18:47 GMT
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
Peter Jamieson - 07 Mar 2005 20:13 GMT
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
> 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
[quoted text clipped - 4 lines]
>
> BILL
 
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.