Not able to print "optional information" fields on lables in mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trekguy1 - 27 May 2005 02:14 GMT

I'm not able to choose which of the items in the "optional information" field
within the match fields dialog box get printed on my labels for a mail merge.
My data appears in the mail merge recipients dialog box, but when I finsih
creating my address block, the "optional information" I had selected is
missing.

Help!

Reply to this Message

Graham Mayor - 27 May 2005 04:32 GMT

What's the data source? And what optional information? If Outlook - see
http://www.gmayor.com/mailmerge_from_outlook.htm
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm may help also.

Signature

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

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

> I'm not able to choose which of the items in the "optional
> information" field within the match fields dialog box get printed on
[quoted text clipped - 3 lines]
>
> Help!

Reply to this Message

trekguy1 - 27 May 2005 06:10 GMT

The source is an Excel spreadsheet. In step 4 of the mail merge wizard, I
click on "Address Block" and the Insert Address Block window comes up. Then
I click on the "Match Fields" button and then the Match Fields window comes
up. In that window there's a list that has "Required Information" (Last
Name, First Name, etc.).
Below that, there's an even bigger list of "Optional Information" (Middle
Name, Sufix, etc.). I'm trying to get a second name to appear (when
necessary) on the second row of the address block on mailing labels. I'm
already using all of the fields in the "Required Information" area, so I was
hoping to use one of the "Optional" ones, Unfortunately, I'm not able to get
them to show up on the label, even when I use the drop-down selection list
that shows the columns in my data source. Any ideas?

> What's the data source? And what optional information? If Outlook - see
> http://www.gmayor.com/mailmerge_from_outlook.htm
[quoted text clipped - 7 lines]
> >
> > Help!

Reply to this Message

Doug Robbins - 27 May 2005 07:06 GMT

Don't use the Address Block. Simply insert the fields that you require in
the configuration that you require.

I would also recomment that instead using the Wizard, you select Toolbars
from the View menu and then check the Mail merge toolbar item. This will
then display a toolbar that gives you access to all of the mailmerge
features.

You should also look at the two web pages to which Graham gave you the links
(if you have not done so already).

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

> The source is an Excel spreadsheet. In step 4 of the mail merge wizard, I
> click on "Address Block" and the Insert Address Block window comes up.
[quoted text clipped - 24 lines]
>> >
>> > Help!

Reply to this Message

trekguy1 - 27 May 2005 17:22 GMT

That helped! Thanks!

> Don't use the Address Block. Simply insert the fields that you require in
> the configuration that you require.
[quoted text clipped - 35 lines]
> >> >
> >> > Help!

Reply to this Message

maghorne - 31 Aug 2005 19:16 GMT

> I'm not able to choose which of the items in the "optional information" field
> within the match fields dialog box get printed on my labels for a mail merge.
[quoted text clipped - 3 lines]
>
> Help!

Reply to this Message

Doug Robbins - 31 Aug 2005 19:24 GMT

Don't use the Address Block. Just insert the mergefields that you want to
use in the configuration that you want them.

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'm not able to choose which of the items in the "optional information"
[quoted text clipped - 7 lines]
>>
>> Help!

Reply to this Message

Rate this thread: