Mail Merge Fields

[Richard]

Quick question - what do i do when i am using MS Excel as
my mail merge source, and i have over 256 mail merge
fields to fill in. I cannot get more columns than this,
and Excel was preferred as i have set up a UserForm for
the users to enter the information into, without ever
touching the Word document.

Any help is appreciated

Richard

 

[Doug Robbins - Word MVP]

You will not be able to use Excel as the data source. I believe that the
only thing that you can use is a delimited text file.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Richard,

I agree with Doug's assessment. The only alternative I can
think of would be to analyze whether you could break this
large Excel table down into "related tables", and create an
Access database from it. For example, if you have fields
that are essentially named "Item1", "Item2", "Item3", etc.
then it's a good candidate.

Quick question - what do i do when i am using MS Excel as
my mail merge source, and i have over 256 mail merge
fields to fill in. I cannot get more columns than this,
and Excel was preferred as i have set up a UserForm for
the users to enter the information into, without ever
touching the Word document.

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

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

 

[Doug Robbins - Word MVP]

Hi Cindy,

AFAIK, the same limit applies to Access tables and queries

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Doug,

AFAIK, the same limit applies to Access tables and queries

The 256 columns, yes. But if the 256 is a result of "Item1",
"Item2", etc. fields that could be broken into separate
tables (normalized), then

1. There are no longer > 256 to deal with

2. We know he's trying to do a 1:many result, which means we
could point him to a workable approach

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

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

 

[Doug Robbins - Word MVP]

Hi Cindy,

Hi Doug,

2. We know he's trying to do a 1:many result, which means we
could point him to a workable approach

From another post? I did not get that from the OP in this thread.[/QUOTE]

 

[Cindy M -WordMVP-]

Hi Doug,

From another post? I did not get that from the OP in this thread.

No, no, no. If he's got Item1, Item2, etc. then we would know that's
what he's trying to do and could help him get his data in order. He
has to respond, though, or all this is moot.

You need to come up for are from the NET stuff and read my posts
through for meaning

Cindy