Mail Merge Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 20 Apr 2004 09:07 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 21 Apr 2004 00:08 GMT

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.

Signature

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

> Quick question - what do i do when i am using MS Excel as
> my mail merge source, and i have over 256 mail merge
[quoted text clipped - 6 lines]
>
> Richard

Reply to this Message

Cindy M -WordMVP- - 21 Apr 2004 15:37 GMT

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

:-)

Reply to this Message

Doug Robbins - Word MVP - 22 Apr 2004 10:43 GMT

Hi Cindy,

AFAIK, the same limit applies to Access tables and queries

Signature

> Hi Richard,
>
[quoted text clipped - 21 lines]
> follow question or reply in the newsgroup and not by e-mail
> :-)

Reply to this Message

Cindy M -WordMVP- - 22 Apr 2004 15:40 GMT

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

:-)

Reply to this Message

Doug Robbins - Word MVP - 23 Apr 2004 06:28 GMT

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.

Signature

Regards
Doug Robbins - Word MVP

Reply to this Message

Cindy M -WordMVP- - 23 Apr 2004 16:11 GMT

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.

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

Reply to this Message