Email Help: Sending Outlook email from Excel VBA

[sam]

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

 

[Dmitry Streblechenko]

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]

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]

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]

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]

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]

I got it to work,
I just had to add this like to the code: ReplyRecipients.Add ("(e-mail address removed)")

Thanks for you time