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 / October 2003

Tip: Looking for answers? Try searching our database.

Mail merge problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PCOR - 12 Oct 2003 01:05 GMT
Hi
A while back I got some real help here...and I am at it again. Here is what
I would like to do:
I am printing receipt for a charitable organization
There will be about 900 receipts to print
I would like to print as follows:
On an 8.5 X 14 sheet, I want to print Receipt No 1 at the top, then a
duplicate of that receipt immedialtely below
In the lower half of the page I want to print receipt No 2 and a duplicate
below that
In other words FOUR receipt(Original No 1 and a duplicate and Original No 2
and duplicate.
Can some please tell me how this can be done
Thanks very much

Signature

Norton Professional 2004 says this email is clean...believe it

Doug Robbins - Word MVP - 12 Oct 2003 04:12 GMT
Hi Ian,

Use a Label type mailmerge with four labels to the sheet and remove the
NextRecord field from second and fourth labels on the sheet.  When you then
execute the merge, you will get what you want.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
> Hi
> A while back I got some real help here...and I am at it again. Here is what
[quoted text clipped - 10 lines]
> Can some please tell me how this can be done
> Thanks very much
PCOR - 12 Oct 2003 05:25 GMT
Sorry about that I clicked the wrong button
I say again
Could you give me a blow by blow description on how to do this
Thanks And ASgain I am sorry for going direct

> Hi Ian,
>
[quoted text clipped - 25 lines]
> > Can some please tell me how this can be done
> > Thanks very much
Doug Robbins - Word MVP - 12 Oct 2003 09:48 GMT
Hi Ian,

You did not tell us what version of Word you are using, so these
instructions will be for Word XP/2003.

Also, I am not sure if there is an Avery label that suits, so we'll start
with just a blank page.

1.    Insert a 4 row by 1 column table
2.    Adjust the height of the rows so that suit the receipts that you want
to create, setting the height to an exact figure.
3.    Enter the fixed text that you want in the first cell
4.    Display the Mail merge toolbar
5.    Click on the Main document setup button and select Labels as the type
of Mail Merge that you want to perform.
6.    Click on Cancel in the Labels dialog that appears.
7.    Click on the Open Data Source button on the Mailmerge Toolbar and open
the datasource that you want to use to create the receipts.
8.    Insert the merge fields containing the data for the receipts in the
first row/cell of the table
9.    Click on the Propogate labels button on the Mail merge tool bar
10.    The contents of the first cell will then be replicated in the other
three cells in the table with a << Next Record>> field beings inserted as
the first item in the second through the fourth cells of the table.
11.    Remove the <<Next Record>> field from the beginning of the second and
the fourth cells of the table
12.    Execute the merge either to the printer or to a new document.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
> Sorry about that I clicked the wrong button
> I say again
[quoted text clipped - 32 lines]
> > > Can some please tell me how this can be done
> > > Thanks very much
PCOR - 12 Oct 2003 14:21 GMT
Hi
I am using version 2002 but all you said worked VERY well
Many thanks
Ian
> Hi Ian,
>
[quoted text clipped - 67 lines]
> > > > Can some please tell me how this can be done
> > > > Thanks very much
Malcolm - 12 Oct 2003 15:07 GMT
While Doug has sent you a technical solution you might
find it as easy to print you batch in duplicate. ie run a
second copy. Or even simply make a photocopy.  I presume
that the second copy is for file purposes.  It would be
easier to keep a single page with 4 receipts than the 4
separate receipts. (Just a thought)
>-----Original Message-----
>Hi
[quoted text clipped - 11 lines]
>Can some please tell me how this can be done
>Thanks very much
PCOR - 12 Oct 2003 15:16 GMT
Thanks BUT
The idea is to send out TWO copies to the donor. One for tax purposes and
the other for his/her records
Thanks for ther effort

> While Doug has sent you a technical solution you might
> find it as easy to print you batch in duplicate. ie run a
[quoted text clipped - 25 lines]
> >
> >.
 
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.