Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email HELP: Add Voting buttons to new message from excel | Excel Programming | |||
Email Voting Buttons | Excel Programming | |||
Outlook Voting button | Excel Programming | |||
Is there any way to use a voting button in excel? | Excel Programming | |||
selecting more than one option button | Excel Discussion (Misc queries) |