Form fields in A Mail Merged Document

M

MaxArk

I have a directory style mail merge document that populates the merge
fields from an Excel database. The document consists mostly of fields
arranged within a table.

The result is two or more records per page represented in individual
tables.

However, not all fields are populated with data from the source. As it
is now, once the new document is made using the mail merge feature, I
have to go in and manually enter information in the blank cells of the
table.

Is it possible, once the new mail merge document is created, I can use
Word's form features to enter information in the document? I am unable
to do this from the template merge document, because each record will
have different values to be manually entered.

If I can't use form features in the new document, how can I scroll from
one empty table cell to the next?

I hope I make sense. If not, please ask me whatever relevant info you
need to help.

Jenn
 
D

Doug Robbins - Word MVP

You could insert ASK fields in the mail merge main document where you want
the insert information for each record. However, that requires that you do
it "on-the-fly" which may not be so easy.

An alternative would be to use a modification of the method in the article
"Combining FormFields and Mail Merge" on the following page of fellow MVP
Graham Mayor's website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

In your case, to end up with the two records per page, you would need to set
up the "main document" with two sets of fields and modify the code so that
it dealt with two records from the data source for each document that it
creates from the template.

--
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, originally posted via msnews.microsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top