mailmerge or formfields

[Nathan Franklin]

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 Robbins - Word MVP]

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]

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]

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