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" <sam@discussions.microsoft.com> wrote in message 
news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
> 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" <sam@discussions.microsoft.com> wrote in message 
> news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
> > 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" <sam@discussions.microsoft.com> wrote in message 
news:8E22B6FF-A314-4E8D-A4D6-F04BA4DC805C@microsoft.com...
> 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" <sam@discussions.microsoft.com> wrote in message
>> news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
>> > 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" <sam@discussions.microsoft.com> wrote in message 
> news:8E22B6FF-A314-4E8D-A4D6-F04BA4DC805C@microsoft.com...
> > 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" <sam@discussions.microsoft.com> wrote in message
> >> news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
> >> > 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" <sam@discussions.microsoft.com> wrote in message 
news:E77FBE92-5973-4D23-AB1F-5DDB7AD2E45D@microsoft.com...
>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" <sam@discussions.microsoft.com> wrote in message
>> news:8E22B6FF-A314-4E8D-A4D6-F04BA4DC805C@microsoft.com...
>> > 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" <sam@discussions.microsoft.com> wrote in message
>> >> news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
>> >> > 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 ("abc@def.com")

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" <sam@discussions.microsoft.com> wrote in message 
> news:E77FBE92-5973-4D23-AB1F-5DDB7AD2E45D@microsoft.com...
> >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" <sam@discussions.microsoft.com> wrote in message
> >> news:8E22B6FF-A314-4E8D-A4D6-F04BA4DC805C@microsoft.com...
> >> > 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" <sam@discussions.microsoft.com> wrote in message
> >> >> news:C8186BBC-9EA2-41F0-94CF-2135FC5E9FC2@microsoft.com...
> >> >> > 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
> >> >>
> >> >>
> >> >> .
> >> >>
> >>
> >>
> >> .
> >> 
> 
> 
> .
>