 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2006Mail Merge Fields in one document
Is there a maximum number of mail merge fields that can be used in one document? If so what is that number. Thanks! Shauna The limit is mostly a function of the data-source. If it's a table in a Word document, you will be limited to a maximum of 64 fields (columns in the table) though it may be less depending upon the width of the columns. If you use Excel or Access as the data source, you are limited to 256 fields (columns) but with a comma delimited file, that number can be exceeded.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Is there a maximum number of mail merge fields that can be used in one > document? If so what is that number. > > Thanks! > Shauna Hi Doug, Yes that helped. Thanks for answering my question. Shauna > The limit is mostly a function of the data-source. If it's a table in a > Word document, you will be limited to a maximum of 64 fields (columns in the [quoted text clipped - 7 lines] > > Thanks! > > Shauna I'm trying to create a mail merge doc from an Access query. Trouble is I can't see the query I need! I've checked the properties of the query against others in the dbase, but there doesn't appear to be any difference. Could it be the number of fields in the query? There are 44? > The limit is mostly a function of the data-source. If it's a table in a > Word document, you will be limited to a maximum of 64 fields (columns in the [quoted text clipped - 7 lines] > > Thanks! > > Shauna From the Tools menu in Word, select Options and then go to the General tab and check the box against "Confirm conversions at open." After you do this, when you attach the data source to the mail merge main document, you will be given a number of options for the method by which the connection should be made. Selecting the DDE option will probably overcome your problem. SignatureHope 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'm trying to create a mail merge doc from an Access query. Trouble is I > can't see the query I need! I've checked the properties of the query [quoted text clipped - 15 lines] >> > Thanks! >> > Shauna > The limit is mostly a function of the data-source. If it's a table in a > Word document, you will be limited to a maximum of 64 fields (columns in the [quoted text clipped - 7 lines] > > Thanks! > > Shauna
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.