ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Email HELP: Add Voting buttons to new message from excel (https://www.excelbanter.com/excel-programming/438014-email-help-add-voting-buttons-new-message-excel.html)

Sam

Email HELP: Add Voting buttons to new message from excel
 
How can add "Voting Buttons" to a message when I send email through excel?

Thanks in advance.



Ron de Bruin

Email HELP: Add Voting buttons to new message from excel
 
Add this to the code

..VotingOptions = "Approved;Disapproved"




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sam" wrote in message ...
How can add "Voting Buttons" to a message when I send email through excel?

Thanks in advance.



Sam

Email HELP: Add Voting buttons to new message from excel
 
This worked out great. I have one more question.

There is an option "Have Replies Sent To" in Voting Buttons section which I
want checked everytime as I want the voting responses send to the person who
requested the vote and to one more person. Is there a way to do it from excel?
To select "Have Replies Sent To" check box and add that other persons email
address

Thanks in advance.

"Ron de Bruin" wrote:

Add this to the code

..VotingOptions = "Approved;Disapproved"




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sam" wrote in message ...
How can add "Voting Buttons" to a message when I send email through excel?

Thanks in advance.


.


Sam

Email HELP: Add Voting buttons to new message from excel
 
Hey Ron,

Did you get a chance to look into it? I tried looking for that specific
voting button property in outllook object browser but couldnt get it to work.

I did find two voting button members "VotingOptions" and "VotingResponse" in
"MailItem" class in outlook object browser but dont know how to get that to
work yet.

There are other members like "CustomPropertyChange" and "CustomAction" in
class "MailItem" but dont know if that is something i need to get this voting
button property selected.

I would appretiate if you could look into this.

"Ron de Bruin" wrote:

Add this to the code

..VotingOptions = "Approved;Disapproved"




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sam" wrote in message ...
How can add "Voting Buttons" to a message when I send email through excel?

Thanks in advance.


.



All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com