Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: How do I mail merge onto 4-up postcards?

Geek News

How do I mail merge onto 4-up postcards?
CJP 3/4/2006 8:07:27 PM
I'm using Avery 8387 and want to mail merge addresses 4 per page, one on each
postcard. I have a template for 2-up that allows for this, but can't find one
for 4-up. How do I set this up?

I've been an Adobe junkie for many years, and am presently learning more
features of the Office suite. Help, please!

CJP
Re: How do I mail merge onto 4-up postcards?
"Doug Robbins - Word MVP" <dkr[ at ]REMOVETHISmvps.org> 3/4/2006 8:15:10 PM
In the label options dialog, select the 8387 - Post Card from the list of
Avery standard Label products.

For more information, 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


--
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

"CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
[Quoted Text]
> I'm using Avery 8387 and want to mail merge addresses 4 per page, one on
> each
> postcard. I have a template for 2-up that allows for this, but can't find
> one
> for 4-up. How do I set this up?
>
> I've been an Adobe junkie for many years, and am presently learning more
> features of the Office suite. Help, please!
>
> CJP


Re: How do I mail merge onto 4-up postcards?
CJP 3/4/2006 11:29:27 PM
Tremendously helpful, thanks so much!

CJP

"Doug Robbins - Word MVP" wrote:

[Quoted Text]
> In the label options dialog, select the 8387 - Post Card from the list of
> Avery standard Label products.
>
> For more information, 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
>
>
> --
> 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
>
> "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
> news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
> > I'm using Avery 8387 and want to mail merge addresses 4 per page, one on
> > each
> > postcard. I have a template for 2-up that allows for this, but can't find
> > one
> > for 4-up. How do I set this up?
> >
> > I've been an Adobe junkie for many years, and am presently learning more
> > features of the Office suite. Help, please!
> >
> > CJP
>
>
>
Re: How do I mail merge onto 4-up postcards?
Thumbpick 5/19/2007 12:10:01 AM
I'd like to piggyback on this series if I may. I'm using 4-up postcards and
can get the mail merge to work on a blank postcard (i.e., one w/o text from
me).

However, I want to type info on the left of the card and mail merge the
addresses in the usual (mid to lower right) of the cards. What happens is I
get an error message: "You cannot include DATA, NEXT, NEXTIF, or SKIPIF
fields in comments, headers, footers, footnotes, or endnotes."

I've tried using tabs, text boxes, etc. Cannot get it to work. Would
appreciate any help you could provide.


I read all thru Mayor's website and cannot find this problem adressed.

"CJP" wrote:

[Quoted Text]
> Tremendously helpful, thanks so much!
>
> CJP
>
> "Doug Robbins - Word MVP" wrote:
>
> > In the label options dialog, select the 8387 - Post Card from the list of
> > Avery standard Label products.
> >
> > For more information, 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
> >
> >
> > --
> > 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
> >
> > "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
> > news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
> > > I'm using Avery 8387 and want to mail merge addresses 4 per page, one on
> > > each
> > > postcard. I have a template for 2-up that allows for this, but can't find
> > > one
> > > for 4-up. How do I set this up?
> > >
> > > I've been an Adobe junkie for many years, and am presently learning more
> > > features of the Office suite. Help, please!
> > >
> > > CJP
> >
> >
> >
Re: How do I mail merge onto 4-up postcards?
Thumbpick 5/19/2007 12:25:00 AM
I'd like to piggyback on this series if I may. I'm using 4-up postcards and
can get the mail merge to work on a blank postcard (i.e., one w/o text from
me).

However, I want to type info on the left of the card and mail merge the
addresses in the usual (mid to lower right) of the cards. What happens is I
get an error message: "You cannot include DATA, NEXT, NEXTIF, or SKIPIF
fields in comments, headers, footers, footnotes, or endnotes."

I've tried using tabs, text boxes, etc. Cannot get it to work. Would
appreciate any help you could provide.

I read all thru Mayor's website and cannot find this problem addressed (no
pun intended).



"Doug Robbins - Word MVP" wrote:

[Quoted Text]
> In the label options dialog, select the 8387 - Post Card from the list of
> Avery standard Label products.
>
> For more information, 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
>
>
> --
> 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
>
> "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
> news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
> > I'm using Avery 8387 and want to mail merge addresses 4 per page, one on
> > each
> > postcard. I have a template for 2-up that allows for this, but can't find
> > one
> > for 4-up. How do I set this up?
> >
> > I've been an Adobe junkie for many years, and am presently learning more
> > features of the Office suite. Help, please!
> >
> > CJP
>
>
>
Re: How do I mail merge onto 4-up postcards?
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/19/2007 5:39:42 AM
Why the second post?

The simplest solution is probably to treat the merge as a letter merge
rather than a label merge, but starting with the label layout.
Divide each of the four postcards into two (the table drawing tool is
perhaps the simplest solution) and then treat each pair of cells as one
postcard. Put your data as required in the left and right cells of the
'card' and put a NEXT record field at the start of the second, third and
fourth cards only (in the left cell).

If you are merging to both sides of the card you'll need to revise your data
file - http://www.gmayor.com/duplex_merge_data.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Thumbpick wrote:
[Quoted Text]
> I'd like to piggyback on this series if I may. I'm using 4-up
> postcards and can get the mail merge to work on a blank postcard
> (i.e., one w/o text from me).
>
> However, I want to type info on the left of the card and mail merge
> the addresses in the usual (mid to lower right) of the cards. What
> happens is I get an error message: "You cannot include DATA, NEXT,
> NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes, or
> endnotes."
>
> I've tried using tabs, text boxes, etc. Cannot get it to work. Would
> appreciate any help you could provide.
>
> I read all thru Mayor's website and cannot find this problem
> addressed (no pun intended).
>
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> In the label options dialog, select the 8387 - Post Card from the
>> list of Avery standard Label products.
>>
>> For more information, 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
>>
>>
>> --
>> 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
>>
>> "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
>> news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
>>> I'm using Avery 8387 and want to mail merge addresses 4 per page,
>>> one on each
>>> postcard. I have a template for 2-up that allows for this, but
>>> can't find one
>>> for 4-up. How do I set this up?
>>>
>>> I've been an Adobe junkie for many years, and am presently learning
>>> more features of the Office suite. Help, please!
>>>
>>> CJP


Re: How do I mail merge onto 4-up postcards?
Thumbpick 5/19/2007 11:56:00 AM
I apologize for the second post... I'm new to these forums and thought the
first post would only go to CJP and nobody else would see it.

Thanks so much.... it works perfectly.

One add'l question: Can I also get it to print postal bar codes? I know how
to do that for envelopes and labels but don't see an option for it in MM.

Thanks again.


"Graham Mayor" wrote:

[Quoted Text]
> Why the second post?
>
> The simplest solution is probably to treat the merge as a letter merge
> rather than a label merge, but starting with the label layout.
> Divide each of the four postcards into two (the table drawing tool is
> perhaps the simplest solution) and then treat each pair of cells as one
> postcard. Put your data as required in the left and right cells of the
> 'card' and put a NEXT record field at the start of the second, third and
> fourth cards only (in the left cell).
>
> If you are merging to both sides of the card you'll need to revise your data
> file - http://www.gmayor.com/duplex_merge_data.htm
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Thumbpick wrote:
> > I'd like to piggyback on this series if I may. I'm using 4-up
> > postcards and can get the mail merge to work on a blank postcard
> > (i.e., one w/o text from me).
> >
> > However, I want to type info on the left of the card and mail merge
> > the addresses in the usual (mid to lower right) of the cards. What
> > happens is I get an error message: "You cannot include DATA, NEXT,
> > NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes, or
> > endnotes."
> >
> > I've tried using tabs, text boxes, etc. Cannot get it to work. Would
> > appreciate any help you could provide.
> >
> > I read all thru Mayor's website and cannot find this problem
> > addressed (no pun intended).
> >
> >
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> In the label options dialog, select the 8387 - Post Card from the
> >> list of Avery standard Label products.
> >>
> >> For more information, 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
> >>
> >>
> >> --
> >> 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
> >>
> >> "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
> >> news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
> >>> I'm using Avery 8387 and want to mail merge addresses 4 per page,
> >>> one on each
> >>> postcard. I have a template for 2-up that allows for this, but
> >>> can't find one
> >>> for 4-up. How do I set this up?
> >>>
> >>> I've been an Adobe junkie for many years, and am presently learning
> >>> more features of the Office suite. Help, please!
> >>>
> >>> CJP
>
>
>
Re: How do I mail merge onto 4-up postcards?
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/19/2007 12:01:43 PM
The barcode produced by Word is POSTNET.

The USPS no longer accepts that format for bulk mail discounts -- see
http://support.microsoft.com/kb/897290. You might as well not use the
barcode feature at all. - but if you insist insert a barcode field.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Thumbpick wrote:
[Quoted Text]
> I apologize for the second post... I'm new to these forums and
> thought the first post would only go to CJP and nobody else would see
> it.
>
> Thanks so much.... it works perfectly.
>
> One add'l question: Can I also get it to print postal bar codes? I
> know how to do that for envelopes and labels but don't see an option
> for it in MM.
>
> Thanks again.
>
>
> "Graham Mayor" wrote:
>
>> Why the second post?
>>
>> The simplest solution is probably to treat the merge as a letter
>> merge rather than a label merge, but starting with the label layout.
>> Divide each of the four postcards into two (the table drawing tool is
>> perhaps the simplest solution) and then treat each pair of cells as
>> one postcard. Put your data as required in the left and right cells
>> of the 'card' and put a NEXT record field at the start of the
>> second, third and fourth cards only (in the left cell).
>>
>> If you are merging to both sides of the card you'll need to revise
>> your data file - http://www.gmayor.com/duplex_merge_data.htm
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> Thumbpick wrote:
>>> I'd like to piggyback on this series if I may. I'm using 4-up
>>> postcards and can get the mail merge to work on a blank postcard
>>> (i.e., one w/o text from me).
>>>
>>> However, I want to type info on the left of the card and mail merge
>>> the addresses in the usual (mid to lower right) of the cards. What
>>> happens is I get an error message: "You cannot include DATA, NEXT,
>>> NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes,
>>> or endnotes."
>>>
>>> I've tried using tabs, text boxes, etc. Cannot get it to work. Would
>>> appreciate any help you could provide.
>>>
>>> I read all thru Mayor's website and cannot find this problem
>>> addressed (no pun intended).
>>>
>>>
>>>
>>> "Doug Robbins - Word MVP" wrote:
>>>
>>>> In the label options dialog, select the 8387 - Post Card from the
>>>> list of Avery standard Label products.
>>>>
>>>> For more information, 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
>>>>
>>>>
>>>> --
>>>> 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
>>>>
>>>> "CJP" <CJP[ at ]discussions.microsoft.com> wrote in message
>>>> news:E859365E-D8A9-4DCC-8210-605CF47E1F1C[ at ]microsoft.com...
>>>>> I'm using Avery 8387 and want to mail merge addresses 4 per page,
>>>>> one on each
>>>>> postcard. I have a template for 2-up that allows for this, but
>>>>> can't find one
>>>>> for 4-up. How do I set this up?
>>>>>
>>>>> I've been an Adobe junkie for many years, and am presently
>>>>> learning more features of the Office suite. Help, please!
>>>>>
>>>>> CJP


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net