Email Help: Sending Outlook email from Excel VBA

#1
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
 
D

Dmitry Streblechenko

#2
If sending through the Outlook Object Model, use the MailItem.VotingOptions

property and MailItem.ReplyRecipients collection.

Dmitry Streblechenko (MVP)

-

"sam" <sam> 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
 
#3
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)
>

>

>

> -
> "sam" <sam> 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


> .
>
 
D

Dmitry Streblechenko

#4
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)

-

"sam" <sam> 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)
> >

> >

> >

> > -
> > "sam" <sam> 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

>

>
>> .
> >
 
#5
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)
>

>

>

> -
> "sam" <sam> 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)
> >>

> >>

> >>

> >> -
> >> "sam" <sam> 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
> >
> >
> >> .
> >>


> .
>
 
D

Dmitry Streblechenko

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

Dmitry Streblechenko (MVP)

-

"sam" <sam> 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)
> >

> >

> >

> > -
> > "sam" <sam> 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)
> > >>

> > >>

> > >>

> > >> -
> > >> "sam" <sam> 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
> > >
>> >
>> >> .
> > >>

>

>
>> .
> >
 
#7
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)
>

>

>

> -
> "sam" <sam> 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)
> >>

> >>

> >>

> >> -
> >> "sam" <sam> 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)
> >> >>

> >> >>

> >> >>

> >> >> -
> >> >> "sam" <sam> 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
> >> >
> >> >
> >> >> .
> >> >
> >
> >
> >> .
> >>


> .
>
 
Top