Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2006

Tip: Looking for answers? Try searching our database.

merge letter with drop down form field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sarah - 24 Jan 2006 20:08 GMT
Hello -

I need to create a merge letter that includes a drop down form field.  The
merge letter is a pretty typical one and I do not have trouble setting it up,
except that there is one item that needs to be included in the letter that
has 3 possible fill-ins.  This is a sentence that needs to be worded exactly
the same way each time it is used.  I would like to add this as a drop down
field to my merge letter in either the letter itself or, preferably, the data
source.  I'm encountering two problems:

1.  Each of the three sentence options are longer than the drop down form
field allows - I'm not sure what the character limitation is, but I'm running
into it.
2.  When I set up the data source as a form, the data does not merge to my
letter correctly.  Is it even possible for a merge letter to contain form
fields, or for the data source to contain form fields?  If not, is there
another way to have a drop down list of options in a merge letter?

Thanks!
Doug Robbins - Word MVP - 24 Jan 2006 21:35 GMT
You cannot use formfields in conjunction with mailmerge.  What you could do
is store the text in separate files and use an IncludeText field in the
mailmerge main document that included a mergefield as the source of the text
to be inserted with the actual source in that field in the datasource.

Signature

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

> Hello -
>
[quoted text clipped - 20 lines]
>
> Thanks!
Sarah - 24 Jan 2006 23:33 GMT
Thanks for the reponse - between when sent my post and read yours, I solved
the problem by creating an AutoText List.  It worked perfectly.  But I
appreciate your help!

> You cannot use formfields in conjunction with mailmerge.  What you could do
> is store the text in separate files and use an IncludeText field in the
[quoted text clipped - 25 lines]
> >
> > Thanks!
 
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.