DROPPED columns in a mailing Lable merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ItsGipper - 12 May 2006 21:12 GMT

I am trying to set up a merged Lable job with 2000 + names -- I am well
versed in the process but am having isses with info Columns being skipped --
Notably Address 2 and the Middle names Columns has anyone encountered or
found a solution to this issue???

Reply to this Message

Doug Robbins - Word MVP - 12 May 2006 22:20 GMT

What is the data source? A mailmerge field should not have spaces in its
name.

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 set up a merged Lable job with 2000 + names -- I am well
> versed in the process but am having isses with info Columns being
> skipped --
> Notably Address 2 and the Middle names Columns has anyone encountered or
> found a solution to this issue???

Reply to this Message

ItsGipper - 12 May 2006 22:54 GMT

The source is a std Excell sheet -- with the column headers named to match
the "Match fields" section e.g. First Name, Address 1 ect. The PROB is that
no matter how many times I go back and forth thru the process -- the merge
will NOT pick up the Middle name column or whichever column I put into the
Address 2 field -- I have swaped the addy 2 & 3 coulmns and which ever one is
in the Address 2 ares will not merge in?

> What is the data source? A mailmerge field should not have spaces in its
> name.
[quoted text clipped - 4 lines]
> > Notably Address 2 and the Middle names Columns has anyone encountered or
> > found a solution to this issue???

Reply to this Message

ItsGipper - 12 May 2006 23:14 GMT

the sourse is an excell spreadsheet and I took out all the spaces -- NO HELP
AT ALL its the space in the MATCH FIELDS area that is the problem -- no
matter what info collumn I assign to the middle name or address 2 area drops
out -- Im frustrated beyond telling I've been at this ALL DAY with no
improvement at all

Reply to this Message

Graham Mayor - 13 May 2006 05:38 GMT

Are you trying to use the AddressBlock field? Don't. Just insert the
individual fields you require.

Signature

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

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

> the sourse is an excell spreadsheet and I took out all the spaces --
> NO HELP AT ALL its the space in the MATCH FIELDS area that is the
[quoted text clipped - 18 lines]
>>> Notably Address 2 and the Middle names Columns has anyone
>>> encountered or found a solution to this issue???

Reply to this Message

Doug Robbins - Word MVP - 13 May 2006 05:48 GMT

Sounds like you are using the Address Block. Don't, just insert the
mergefields that you want to use into the mailmerge main document in the
configuration that want.

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 sourse is an excell spreadsheet and I took out all the spaces -- NO
> HELP
[quoted text clipped - 13 lines]
>> > or
>> > found a solution to this issue???

Reply to this Message