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 / Programming / August 2006

Tip: Looking for answers? Try searching our database.

resolving combo box data to HTML e-mail

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rollneck - 30 Aug 2006 10:01 GMT
hi,

I am creating a template in word to replace an existing paper based form
with a e-mailed word document. To do this i am using VBA in word to send the
document once finished and i am using several combo box's to select data on
the document. The problem i am having is that when the template is sent (as
HTML) the data selected in the combo box's is not sent. I would like to have
it set so that only the text selected in the combo box is sent - without any
of the actual comboi box.

(i am aware that the combo box can be sent by activating active x in
outlook, however i was hoping that there might be another way)

where can i find the answer???

thanks.
Cindy M. - 30 Aug 2006 10:43 GMT
Hi =?Utf-8?B?cm9sbG5lY2s=?=,

> I am creating a template in word to replace an existing paper based form
> with a e-mailed word document. To do this i am using VBA in word to send the
[quoted text clipped - 6 lines]
> (i am aware that the combo box can be sent by activating active x in
> outlook, however i was hoping that there might be another way)

Use Dropdown form fields instead of ActiveX controls. "Unlink" all the fields
to plain text before sending (doc.Range.Fields.Unlink)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
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.