Is there a limit on the number of merge fields I can use?

I’m trying to set up a mail merge document with Word & excel 2007. Is there
a limit on the number of merge fields I can use? My spreadsheet has 200+
columns that are each a merge field. When I try to merge documents, many of
the fields at the end of the spreadsheet aren’t viewable.

Any suggestions for a workaround will be appreciated.

Do they print anyway?

Lee wrote:
I’m trying to set up a mail merge document with Word & excel 2007. Is there
a limit on the number of merge fields I can use? My spreadsheet has 200+
columns that are each a merge field. When I try to merge documents, many of
the fields at the end of the spreadsheet aren’t viewable.

Any suggestions for a workaround will be appreciated.

No, they don't print. I can't enter the fields in Word, they are not available.

"Bob I" wrote:

Do they print anyway?

Lee wrote:
I’m trying to set up a mail merge document with Word & excel 2007. Is there
a limit on the number of merge fields I can use? My spreadsheet has 200+
columns that are each a merge field. When I try to merge documents, many of
the fields at the end of the spreadsheet aren’t viewable.

Any suggestions for a workaround will be appreciated.

The mail merge Wizard stops at 255 fields. Perhaps that is where the
problem for you is. 200+ should not be a problem but 255+ would be.

Lee wrote:

No, they don't print. I can't enter the fields in Word, they are not available.

"Bob I" wrote:


Do they print anyway?

Lee wrote:

I’m trying to set up a mail merge document with Word & excel 2007. Is there
a limit on the number of merge fields I can use? My spreadsheet has 200+
columns that are each a merge field. When I try to merge documents, many of
the fields at the end of the spreadsheet aren’t viewable.

Any suggestions for a workaround will be appreciated.

Hi Lee,

You may want to also post this in the Word mailmerge and fields discussion group using the link below with the steps you're using
in Word 2007.

===========
"Lee" wrote in message ...
No, they don't print. I can't enter the fields in Word, they are not available.
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsof...ilmerge.fields
or via browser:
http://microsoft.com/communities/new...ilmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/communit...s/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com