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 / February 2007

Tip: Looking for answers? Try searching our database.

Graham Mayor - Insert Text From Dropdown form feild

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
justagrunt - 15 Feb 2007 21:31 GMT
Hi Graham,
Word 2000.
I'm trying to use the example of inserting text from a dropdown form field
and have a dew questions.
Basically I have a mail merge document which populates from access. I
figured if I added your example of a drop down to the letter, the user could
then decide what additional text or docs to add after the merge was completed.

If we start from a mail merged document template.
I have followed the example and added a dropdown along with the field codes
etc and the exit macro and ticked the correct boxes in the options. The drop
down function doesn't work i.e there is no ability to select a document (Job)
of which I have 11. I used the form toolbar to place the dropdown on the
document. With the design function removed the untouched document has a
greyed feild, it is a bookmark called "Dropdown1".
The feild on the document shows section1 which is one of the 11 documents
which is in the drop-down item list - its happens to be the first one.
No drop down working.

When the mail merge was complete the letter was formatted and low and behold
the whole of section1 had been pasted and the field "Section1" was also
showing. I had hoped that there would be a dropdown list like a combo box
visible somewhere to select a document.

What have I done wrong?
Can this dropdown be used to select and add 3 or 4 or the whole lot - one at
a time by repeated selection?

My quest is a marthon at present - but I figure eventually I will get
something that works to add automatically other portions of text to a
document.

Thanks for your assitance.
Signature

Regards
Bill

Doug Robbins - Word MVP - 16 Feb 2007 04:41 GMT
Formfields and mail merge are not compatible.

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

> Hi Graham,
> Word 2000.
[quoted text clipped - 36 lines]
>
> Thanks for your assitance.
justagrunt - 17 Feb 2007 03:36 GMT
Thanks Doug,
Drat - slowly finding the limitations of automation etc.
Much appreciated.
Plan "D" time.
Signature

Regards
Bill

> Formfields and mail merge are not compatible.
>
[quoted text clipped - 38 lines]
> >
> > Thanks for your assitance.
Doug Robbins - Word MVP - 17 Feb 2007 06:31 GMT
For Plan "D", in place of the mail merge main document, I would create a
template in which I would have {DOCVARIABLE fieldname } fields in place of
the {MERGEFIELD fieldname } fields.   Then I would create a macro that would
access the datasource and iterate through the records, for each record,
creating a new document from the template and creating Document Variable
fields in that document that contained the data from the current record and
then updated the fields in the new document so that the data that was stored
in those variables appeared in the { DOCVARIABLE } fields.

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

> Thanks Doug,
> Drat - slowly finding the limitations of automation etc.
[quoted text clipped - 48 lines]
>> >
>> > Thanks for your assitance.
 
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.