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 / November 2006

Tip: Looking for answers? Try searching our database.

Multiple mail merge on single A4 sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
oldbuffer - 10 Nov 2006 17:36 GMT
Dear All,

Apologies for the long winded "subject" but what I'm trying to do is easier
to demonstrate rather than explain - but here goes..

As a result of serious increases in postal charges particularly regarding
envelope sizes, I am trying to arrange distribution of our Tennis Club
subscription renewals by halving the physical size of the invoices (ie two
bills on one sheet instead of one bill on a single sheet). The problem I have
is trying to mail merge the information from an Excel Database on to the two
bills, such that the first on the list appears in the top bill, the second on
the list appears in the lower bill and so on - ie I'm trying to fool Word
into thinking that one A4 sheet is in fact two separate sheets. As it stands
at the moment, I can only merge information in the top bill - the bottom one
stays blank. The next on the list then appears in the top half of another
sheet...

Any ideas would be gratefully acknowledged.

thanks and rgds

PT.
Doug Robbins - Word MVP - 11 Nov 2006 00:31 GMT
Use a label type mailmerge main document using the Avery J8168 Shipping
Label.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Dear All,
>
[quoted text clipped - 24 lines]
>
> PT.
oldbuffer - 11 Nov 2006 10:33 GMT
Hi Doug,

A brilliant solution!! Apart from a minor mod to content, the "labels"
worked a charm.  You've saved me a fortune in time and money!! Many thanks

Paul.

> Use a label type mailmerge main document using the Avery J8168 Shipping
> Label.
[quoted text clipped - 27 lines]
> >
> > PT.
 
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.