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