mailmerge or formfields

Hello List,

I have a question. I was wandering what the best method is to put data into
a word document. At the moment I am using mail merge, but I heard that mail
merge does a maximum of 63 fields?? Is this true. I am currently at 59
fields, And I am still adding fields every now and again. I am only
generating 1 document. So I was thinking maybe form fields might be better?
Which will work the best and be most efficient?

Thanks Nathan

Doug
Thu Apr 27 15:41:56 CDT 2006

The number of mergefields depends on your sanity and the source of the data.
While a data source in a Word Table is limited to the maximum number of
columns that you can have in a Word table (64), an Excel Spreadsheet or an
Access Database Table can have up to 256 fields.

--
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

"Nathan Franklin" <nat_notthis_han@ts-notthis-n.cc> wrote in message
news:e2oupo$qgs$1@news-02.connect.com.au...
> Hello List,
>
> I have a question. I was wandering what the best method is to put data
> into a word document. At the moment I am using mail merge, but I heard
> that mail merge does a maximum of 63 fields?? Is this true. I am currently
> at 59 fields, And I am still adding fields every now and again. I am only
> generating 1 document. So I was thinking maybe form fields might be
> better? Which will work the best and be most efficient?
>
> Thanks Nathan
>

Nathan
Thu Apr 27 17:29:20 CDT 2006

Thx for your reply Doug,

A question with mailmerge then, when a merge field doesnt exist in the
document, is there way I can stop the field not found dialog box from
appearing. I mean is there any options i can pass when starting a mailmerge
with .Merge to tell it to be silent??

Thanks doug

Nathan

"Doug Robbins - Word MVP" <dkr@REMOVETHISmvps.org> wrote in message
news:OYsTKsjaGHA.4916@TK2MSFTNGP04.phx.gbl...
> The number of mergefields depends on your sanity and the source of the
> data. While a data source in a Word Table is limited to the maximum number
> of columns that you can have in a Word table (64), an Excel Spreadsheet or
> an Access Database Table can have up to 256 fields.
>
> --
> 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
>
> "Nathan Franklin" <nat_notthis_han@ts-notthis-n.cc> wrote in message
> news:e2oupo$qgs$1@news-02.connect.com.au...
>> Hello List,
>>
>> I have a question. I was wandering what the best method is to put data
>> into a word document. At the moment I am using mail merge, but I heard
>> that mail merge does a maximum of 63 fields?? Is this true. I am
>> currently at 59 fields, And I am still adding fields every now and again.
>> I am only generating 1 document. So I was thinking maybe form fields
>> might be better? Which will work the best and be most efficient?
>>
>> Thanks Nathan
>>
>
>

Doug
Fri Apr 28 14:41:00 CDT 2006

The issue is not the mergefield not being in the document, it is having a
mergefield in the document that does not exist in the data source.

--
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

"Nathan Franklin" <nat_notthis_han@ts-notthis-n.cc> wrote in message
news:e2rgk3$kbv$1@news-02.connect.com.au...
> Thx for your reply Doug,
>
> A question with mailmerge then, when a merge field doesnt exist in the
> document, is there way I can stop the field not found dialog box from
> appearing. I mean is there any options i can pass when starting a
> mailmerge with .Merge to tell it to be silent??
>
> Thanks doug
>
> Nathan
>
> "Doug Robbins - Word MVP" <dkr@REMOVETHISmvps.org> wrote in message
> news:OYsTKsjaGHA.4916@TK2MSFTNGP04.phx.gbl...
>> The number of mergefields depends on your sanity and the source of the
>> data. While a data source in a Word Table is limited to the maximum
>> number of columns that you can have in a Word table (64), an Excel
>> Spreadsheet or an Access Database Table can have up to 256 fields.
>>
>> --
>> 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
>>
>> "Nathan Franklin" <nat_notthis_han@ts-notthis-n.cc> wrote in message
>> news:e2oupo$qgs$1@news-02.connect.com.au...
>>> Hello List,
>>>
>>> I have a question. I was wandering what the best method is to put data
>>> into a word document. At the moment I am using mail merge, but I heard
>>> that mail merge does a maximum of 63 fields?? Is this true. I am
>>> currently at 59 fields, And I am still adding fields every now and
>>> again. I am only generating 1 document. So I was thinking maybe form
>>> fields might be better? Which will work the best and be most efficient?
>>>
>>> Thanks Nathan
>>>
>>
>>
>
>