Outlook Email Help: selecting Voting button option from excel VBA

[sam]

Hi All,
I had a question about sending email from excel. I know we can set certain
properties of outlook from excel such as "Send Receipt" ect.. But can we set
an voting button option from excel?

I am able to send the voting buttons through excel by doing:
..VotingOptions = "Accept;Reject"

But There is an option "Have Replies Sent To" in Voting Buttons section
which I want checked everytime as I want the voting responses sent to the
person who requested the vote AND to one more person. Is there a way to do
this from excel?

To select "Have Replies Sent To" check box and add that other persons email
address

Thanks in advance.

 

[Ron de Bruin]

Must look at this if I have time Sam (I never used the buttons myself)

But you can do this to change the reply address (maybe not what you want ?0
.SentOnBehalfOfName = """SenderName"" <[email protected]>"

 

[sam]

Hey Ron,

Thanks for helping. I want to send the voting response to the person who has
requested to vote as well.

For eg:

Person1: sends an email to Person2 and Person3 for their votes

Person2 votes and the voting reply is sent to Person1 and Person3

Person3 votes and the voting reply is send to Person1 and Person2

I think with ".SentOnBehalfOfName" the reply will be sent to one person only
on voting?

Thanks in advance

 

[Ron de Bruin]

Hi Sam

I put it on my list of things to look at it this week(weekend)

 

[sam]

Thanks for looking into it Ron.

Hi Sam

I put it on my list of things to look at it this week(weekend)

--

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



.

 

[sam]

Hey Ron,

Did you get a chance to look into it? I tried looking for it in outlook
object browser but couldnt find it.

Let me know if you find it.

Thanks for helping

 

[Ron de Bruin]

I try to look at it this evening

 

[sam]

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.

 

[sam]

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]

Hi Sam

I have try a few things but I not think this is possible.
You can ask it in the Outlook newsgroups to see if they can help you

 

[sam]

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.

 

[sam]

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]

I reply yesterday Sam with this

Hi Sam

I have try a few things but I not think this is possible.
You can ask it in the Outlook newsgroups to see if they can help you