Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   how do I use a drop down list in an email message (http://www.outlookbanter.com/outlook-using-forms/34013-how-do-i-use-drop.html)

lwood629 November 28th 06 08:26 PM

how do I use a drop down list in an email message
 
I send an email message over and over with only slight changes and wanted to
make use of a drop down list in the email. However when I send the message
the drop down item can't be seen by the person I sent the message to.

What am I doing wrong

Sue Mosher [MVP-Outlook] November 28th 06 08:36 PM

how do I use a drop down list in an email message
 
It's impossible to say what you did wrong since we don't know what you did in the first place, nor your Outlook version, what mail program the other person is using, whether you're both working for the same company and have Exchange for your mail server -- all of which is relevant.

The short answer, however, is: You probably did nothing wrong other than try to do something with email that it just doesn't generally support.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"lwood629" wrote in message ...
I send an email message over and over with only slight changes and wanted to
make use of a drop down list in the email. However when I send the message
the drop down item can't be seen by the person I sent the message to.

What am I doing wrong


lwood629 November 28th 06 08:50 PM

how do I use a drop down list in an email message
 
I am using Outlook 2002. I am working on a college campus and sending a
similar email frequently with slight changes, I attempted to use design form
feature but the drop down item does not appear at the other end.

Can you recommend something else to try?

"Sue Mosher [MVP-Outlook]" wrote:

It's impossible to say what you did wrong since we don't know what you did in the first place, nor your Outlook version, what mail program the other person is using, whether you're both working for the same company and have Exchange for your mail server -- all of which is relevant.

The short answer, however, is: You probably did nothing wrong other than try to do something with email that it just doesn't generally support.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"lwood629" wrote in message ...
I send an email message over and over with only slight changes and wanted to
make use of a drop down list in the email. However when I send the message
the drop down item can't be seen by the person I sent the message to.

What am I doing wrong



Sue Mosher [MVP-Outlook] November 28th 06 09:38 PM

how do I use a drop down list in an email message
 
Put the drop-down list on a VBA form and use code for that form to generate the new message and fill in the value from the drop-down list. A useful technique is to create the message with a token (e.g. %myfield%) where you want the drop-down list selection to appear. Save that message as an .oft file. Your code can then load it with the Application.CreateItemFromTemplate method and use a simple Replace() to change the message's HTMLBody property, swapping out the token text for the list text.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"lwood629" wrote in message ...
I am using Outlook 2002. I am working on a college campus and sending a
similar email frequently with slight changes, I attempted to use design form
feature but the drop down item does not appear at the other end.

Can you recommend something else to try?

"Sue Mosher [MVP-Outlook]" wrote:

It's impossible to say what you did wrong since we don't know what you did in the first place, nor your Outlook version, what mail program the other person is using, whether you're both working for the same company and have Exchange for your mail server -- all of which is relevant.

The short answer, however, is: You probably did nothing wrong other than try to do something with email that it just doesn't generally support.

"lwood629" wrote in message ...
I send an email message over and over with only slight changes and wanted to
make use of a drop down list in the email. However when I send the message
the drop down item can't be seen by the person I sent the message to.

What am I doing wrong



lwood629 November 28th 06 09:56 PM

how do I use a drop down list in an email message
 
Thanks, I give it a try

"Sue Mosher [MVP-Outlook]" wrote:

Put the drop-down list on a VBA form and use code for that form to generate the new message and fill in the value from the drop-down list. A useful technique is to create the message with a token (e.g. %myfield%) where you want the drop-down list selection to appear. Save that message as an .oft file. Your code can then load it with the Application.CreateItemFromTemplate method and use a simple Replace() to change the message's HTMLBody property, swapping out the token text for the list text.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"lwood629" wrote in message ...
I am using Outlook 2002. I am working on a college campus and sending a
similar email frequently with slight changes, I attempted to use design form
feature but the drop down item does not appear at the other end.

Can you recommend something else to try?

"Sue Mosher [MVP-Outlook]" wrote:

It's impossible to say what you did wrong since we don't know what you did in the first place, nor your Outlook version, what mail program the other person is using, whether you're both working for the same company and have Exchange for your mail server -- all of which is relevant.

The short answer, however, is: You probably did nothing wrong other than try to do something with email that it just doesn't generally support.

"lwood629" wrote in message ...
I send an email message over and over with only slight changes and wanted to
make use of a drop down list in the email. However when I send the message
the drop down item can't be seen by the person I sent the message to.

What am I doing wrong




All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com