Why will mailmerge not use all the fields from data source?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenny H - 20 Feb 2006 10:30 GMT

I am trying to produce a document in Word which uses data from Excel, the
data extends to column GA and there are 85 records. Data consists of text and
then number and calculated numbers.
When I attempt to mailmerge, it only picks up columns up to W, basically the
text columns. Is there a limit to the number of columns that can be merged?

Thanks for any advice.
Jenny

Reply to this Message

Doug Robbins - Word MVP - 20 Feb 2006 12:13 GMT

The number of fields are only limited by the number of columns in the data
source which with Excel is 256. Did you insert all of the fields into the
mailmerge main document?

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 produce a document in Word which uses data from Excel, the
> data extends to column GA and there are 85 records. Data consists of text
[quoted text clipped - 7 lines]
> Thanks for any advice.
> Jenny

Reply to this Message

Jenny H - 20 Feb 2006 12:39 GMT

Hi Doug, thanks for the reply. I just directed the mailmerge to the Excel
document and presumed that it would bring in all the columns, but it didn't.
Is it possible to insert them manually as well? I couldn't see an obvious
way how to.

Sorry, I don't use mailmerge very often!
Jenny

> The number of fields are only limited by the number of columns in the data
> source which with Excel is 256. Did you insert all of the fields into the
[quoted text clipped - 11 lines]
> > Thanks for any advice.
> > Jenny

Reply to this Message

Doug Robbins - Word MVP - 20 Feb 2006 17:03 GMT

You have to insert a mergefield for each column in the worksheet. The names
in the cells of the first row of the worksheet must be useable as mergefield
names.

See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

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

> Hi Doug, thanks for the reply. I just directed the mailmerge to the
> Excel
[quoted text clipped - 26 lines]
>> > Thanks for any advice.
>> > Jenny

Reply to this Message