mailMere is adding an extra field in output

[Nancy Baumgarten]

HI, guys, appreciate any hlep. I am using Office 2000 and have used mailmerge for years. All of a sudden mailmerge is adding an extra field and throwing off the whole thing including wrapping the address line onto the city line and deleteing the zipcode...

tried everything to elan up any extraneous stuff. This database (excel goes through BU for the number of columns... but it doesn't seem to have anyporblem with that...

any suggestions?
Thanks, Nancy

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TmFuY3kgQmF1bWdhcnRlbg==?=,

I am using Office 2000 and have used mailmerge for years. All of a sudden

mailmerge is adding an extra field and throwing off the whole thing including
wrapping the address line onto the city line and deleteing the zipcode...What field (Press Alt+F9 to see the field codes)? A field in your data source?

tried everything to elan up any extraneous stuff. This database (excel goes

through BU for the number of columns... but it doesn't seem to have anyporblem
with that...What is "BU"?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Cindy M -WordMVP-]

Hi Nancy

Mail maerge is adding a second first name and placing it on the second line for

labels which skews evrything else. Have you evrheard of this?Never heard of anything like it.

In my database which is so many columns wide, that printed out it takes four

sheets, I do have the students name and first name repeated at the beginning of
each sheet....

but that shouldnt'be a problem since I can easilty see which colum to use. I

use the first two and then for the addresses which are at the end I pick those...Since I didn't get any response to the questions in my first reply I'll try
rephrasing and see if that helps.

In the main merge document, press Alt+F9 so that you can see the FIELD CODES for
the merge fields. Can you see what field code is delivering the "odd"
information?

One thing that does occur to me is that, somehow, a FirstName field has gotten
inserted into the field codes of the merge field on that second line. This can
happen, and you can't do anything to "pull it apart" once it does, short of
deleting the fields on that line and reinserting them. Try that?

And what, please, is the "BU" you refer to in your original posting?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail