ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Outlook Email Help: selecting Voting button option from excel VBA (https://www.excelbanter.com/excel-programming/438061-outlook-email-help-selecting-voting-button-option-excel-vba.html)

Sam

Outlook Email Help: selecting Voting button option from excel VBA
 
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

Outlook Email Help: selecting Voting button option from excel VBA
 
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"" "



--

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


"sam" wrote in message ...
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.


Sam

Outlook Email Help: selecting Voting button option from excel
 
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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

Outlook Email Help: selecting Voting button option from excel
 
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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.

.


Sam

Outlook Email Help: selecting Voting button option from excel
 
Thanks for looking into it Ron.


"Ron de Bruin" wrote:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.


Sam

Outlook Email Help: selecting Voting button option from excel
 
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" wrote:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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

Outlook Email Help: selecting Voting button option from excel
 
I try to look at it this evening

--

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


"sam" wrote in message ...
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" wrote:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.


Sam

Outlook Email Help: selecting Voting button option 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:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.


Sam

Outlook Email Help: selecting Voting button option 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:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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

Outlook Email Help: selecting Voting button option from excel
 
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


--

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


"Ron de Bruin" wrote in message ...
I try to look at it this evening

--

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


"sam" wrote in message ...
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" wrote:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.


Sam

Outlook Email Help: selecting Voting button option 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:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.


Sam

Outlook Email Help: selecting Voting button option 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:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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

Outlook Email Help: selecting Voting button option from excel
 
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


--

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


"sam" wrote in message ...
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:

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" wrote in message ...
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" wrote:

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"" "



--

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


"sam" wrote in message ...
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.
.

.



All times are GMT +1. The time now is 11:42 PM.

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