Mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trish morpeth - 29 Jan 2007 20:09 GMT

I am trying to print two different membership cards on one page. How do I do
it? The cards are pre-printed with spaces for names, nos. etc. but there are
2 of them to a sheet. I can't tear them in half as they wont go through the
printer consistently straight.
I'm using Access 2003

Reply to this Message

Doug Robbins - Word MVP - 29 Jan 2007 20:41 GMT

You can do this with a formletter type mail merge, using your Access data as
a mail merge data source. You will need to position two sets of the merge
fields in the appropriate positions so that they line up with the spaces on
the pre-printed cards. The best way to do that may be to insert a table
into the mail merge main document with the cells of the table set to fixed
dimensions so that the mergefields are in the right place. In front of the
first mergefield in the second set of merge fields, insert a Next Record
field (via the Insert>Word Fields button.

I would suggest that you turn on the display of the mailmerge toolbar by
selecting Toolbars from the View menu and then check the Mail Merge item.

It may also help you to see the article "Mailmerge Labels with Word XP" on
fellow MVP Graham Mayor's website at:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

>I am trying to print two different membership cards on one page. How do I
>do
[quoted text clipped - 4 lines]
> printer consistently straight.
> I'm using Access 2003

Reply to this Message

trish morpeth - 29 Jan 2007 22:19 GMT

Many thanks.. My next problem is when there are only 3 lines of address
instead of the 4 fields which I've inserted. It then distorts the next
record and/or the other part of the membership card by being a row too high.

> I am trying to print two different membership cards on one page. How do I do
> it? The cards are pre-printed with spaces for names, nos. etc. but there are
> 2 of them to a sheet. I can't tear them in half as they wont go through the
> printer consistently straight.
> I'm using Access 2003

Reply to this Message

Peter Jamieson - 29 Jan 2007 23:01 GMT

> My next problem is when there are only 3 lines of address
> instead of the 4 fields which I've inserted.

Try one of the following:
a. use Insert|Symbol|"Special Characters" to insert an "Em space", "En
space" or "1/4 En space" character at the end of each line that could
contain a blank field. Don't use a "Non-breaking space" - it's not enough.
b. or click Tools|Customize|Commands, select catageory All Commands, then
locate MailMergeHelper in the list of commands in the right hand column and
drag it to a toolbar. Close the Customize dialog, click the icon you just
created, click the Merge.. button under "3", select the Print Blank Lines
when Data fields are Empty option, then close the dialog.
c. or if you know how to use VBA you can do the same as (b) using

Sub NoSuppressBlankLines()
ActiveDocument.MailMerge.SuppressBlankLines = False
End Sub

There are other possible ways but if none of those work, something else is
probably wrong...

Peter Jamieson

> Many thanks.. My next problem is when there are only 3 lines of address
> instead of the 4 fields which I've inserted. It then distorts the next
[quoted text clipped - 9 lines]
>> printer consistently straight.
>> I'm using Access 2003

Reply to this Message

trish morpeth - 31 Jan 2007 21:13 GMT

Thank you so much. I have successfully printed 713 membership cards and have
learned so much with you help. It's so easy when you know the answer.
Trish Morpeth

> > My next problem is when there are only 3 lines of address
> > instead of the 4 fields which I've inserted.
[quoted text clipped - 32 lines]
> >> printer consistently straight.
> >> I'm using Access 2003

Reply to this Message

trish morpeth - 31 Jan 2007 21:16 GMT

> Many thanks.. My next problem is when there are only 3 lines of address
> instead of the 4 fields which I've inserted. It then distorts the next
[quoted text clipped - 5 lines]
> > printer consistently straight.
> > I'm using Access 2003

Reply to this Message

Rate this thread: