Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email HELP: Add Voting buttons to new message from excel Sam Excel Programming 3 January 10th 10 10:07 PM
Email Voting Buttons Richard Excel Programming 3 October 7th 08 08:26 AM
Outlook Voting button Andrew[_40_] Excel Programming 1 June 21st 06 05:18 AM
Is there any way to use a voting button in excel? mmonk Excel Programming 0 October 4th 05 02:25 PM
selecting more than one option button Katie-Baughman Excel Discussion (Misc queries) 4 May 6th 05 02:24 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"