Hi All,

How do I select a specific property in outlook while sending email from excel?

There is an option we can set in outlook outgoing emails call "Voting buttons"
in that feature there is a custom option that we can select called "Have
replies sent to" its a checkbox. I want it checked when i send an email from
excel.

Hope i made it clear.

Thanks in advance

If sending through the Outlook Object Model, use the MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email from
excel?

There is an option we can set in outlook outgoing emails call "Voting
buttons"
in that feature there is a custom option that we can select called "Have
replies sent to" its a checkbox. I want it checked when i send an email
from
excel.

Hope i made it clear.

Thanks in advance

Hey Dmitry,

Thanks for the help.

I am sending the emails through Excel. Is there a way to do it from excel?

Thanks in advance

"Dmitry Streblechenko" wrote:

If sending through the Outlook Object Model, use the MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email from
excel?

There is an option we can set in outlook outgoing emails call "Voting
buttons"
in that feature there is a custom option that we can select called "Have
replies sent to" its a checkbox. I want it checked when i send an email
from
excel.

Hope i made it clear.

Thanks in advance


.

I don't know Excel Object Model, does it have a function to send e-mails?
Why not use the Outlook Object Model?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hey Dmitry,

Thanks for the help.

I am sending the emails through Excel. Is there a way to do it from excel?

Thanks in advance

"Dmitry Streblechenko" wrote:

If sending through the Outlook Object Model, use the
MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email from
excel?

There is an option we can set in outlook outgoing emails call "Voting
buttons"
in that feature there is a custom option that we can select called
"Have
replies sent to" its a checkbox. I want it checked when i send an email
from
excel.

Hope i made it clear.

Thanks in advance


.

I generate reports in excel using VBA and macros and have created a button
which email the reports to respective managers once the report is ready.
Thats the reason I want it in excel.

There is no inbuilt function in excel that sends email through outlook, You
have to manually code in VBA to make it happen. I have already coded it such
that It sends the email to the respective managers with the voting buttons
option enabled, But I am struggeling with selecting this specific custom
option in voting button that I want checked when the email is sent.

I think, we can code the same way as we would code in outlook to make this
to work. But I dont know how to get this specific thing to work.

Could you please show me how it is done in outlook, So I can try and do it
in excel.

Thanks in advance

"Dmitry Streblechenko" wrote:

I don't know Excel Object Model, does it have a function to send e-mails?
Why not use the Outlook Object Model?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hey Dmitry,

Thanks for the help.

I am sending the emails through Excel. Is there a way to do it from excel?

Thanks in advance

"Dmitry Streblechenko" wrote:

If sending through the Outlook Object Model, use the
MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email from
excel?

There is an option we can set in outlook outgoing emails call "Voting
buttons"
in that feature there is a custom option that we can select called
"Have
replies sent to" its a checkbox. I want it checked when i send an email
from
excel.

Hope i made it clear.

Thanks in advance


.



.

So what is your VBA code tha tyou are having problems with?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
I generate reports in excel using VBA and macros and have created a button
which email the reports to respective managers once the report is ready.
Thats the reason I want it in excel.

There is no inbuilt function in excel that sends email through outlook,
You
have to manually code in VBA to make it happen. I have already coded it
such
that It sends the email to the respective managers with the voting buttons
option enabled, But I am struggeling with selecting this specific custom
option in voting button that I want checked when the email is sent.

I think, we can code the same way as we would code in outlook to make this
to work. But I dont know how to get this specific thing to work.

Could you please show me how it is done in outlook, So I can try and do it
in excel.

Thanks in advance

"Dmitry Streblechenko" wrote:

I don't know Excel Object Model, does it have a function to send e-mails?
Why not use the Outlook Object Model?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hey Dmitry,

Thanks for the help.

I am sending the emails through Excel. Is there a way to do it from
excel?

Thanks in advance

"Dmitry Streblechenko" wrote:

If sending through the Outlook Object Model, use the
MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email
from
excel?

There is an option we can set in outlook outgoing emails call
"Voting
buttons"
in that feature there is a custom option that we can select called
"Have
replies sent to" its a checkbox. I want it checked when i send an
email
from
excel.

Hope i made it clear.

Thanks in advance


.



.

I got it to work,
I just had to add this like to the code: ReplyRecipients.Add ")

Thanks for you time

"Dmitry Streblechenko" wrote:

So what is your VBA code tha tyou are having problems with?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
I generate reports in excel using VBA and macros and have created a button
which email the reports to respective managers once the report is ready.
Thats the reason I want it in excel.

There is no inbuilt function in excel that sends email through outlook,
You
have to manually code in VBA to make it happen. I have already coded it
such
that It sends the email to the respective managers with the voting buttons
option enabled, But I am struggeling with selecting this specific custom
option in voting button that I want checked when the email is sent.

I think, we can code the same way as we would code in outlook to make this
to work. But I dont know how to get this specific thing to work.

Could you please show me how it is done in outlook, So I can try and do it
in excel.

Thanks in advance

"Dmitry Streblechenko" wrote:

I don't know Excel Object Model, does it have a function to send e-mails?
Why not use the Outlook Object Model?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hey Dmitry,

Thanks for the help.

I am sending the emails through Excel. Is there a way to do it from
excel?

Thanks in advance

"Dmitry Streblechenko" wrote:

If sending through the Outlook Object Model, use the
MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"sam" wrote in message
...
Hi All,

How do I select a specific property in outlook while sending email
from
excel?

There is an option we can set in outlook outgoing emails call
"Voting
buttons"
in that feature there is a custom option that we can select called
"Have
replies sent to" its a checkbox. I want it checked when i send an
email
from
excel.

Hope i made it clear.

Thanks in advance


.



.



.