If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form fields in A Mail Merged Document
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 |
#2
|
|||
|
|||
Form fields in A Mail Merged Document
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 "MaxArk" wrote in message ... 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 -- MaxArk |
Thread Tools | |
Display Modes | |
|
|