A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form fields in A Mail Merged Document



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2009, 06:16 PM
MaxArk MaxArk is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2008
Posts: 35
Default 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  
Old June 7th, 2009, 10:06 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.