Email Help: Sending Outlook email from Excel VBA

Status
Not open for further replies.
S

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


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

>

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


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

>

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


> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Help sending email but removing signature via VBA Outlook VBA and Custom Forms 5
A Outlook 2019 Help with forwarding email without mentioning the previous email sender. Outlook VBA and Custom Forms 0
X Open Hyperlinks in an Outlook Email Message (Help with Diane's solution) Outlook VBA and Custom Forms 3
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
J Help Needed With Multi-Step Login Email Address Using Outlook.com accounts in Outlook 1
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
P A single email forwarded - HELP Using Outlook 1
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
P Automatically 'Reply to all', and Change the Subject of Email - Diane P help! Using Outlook 0
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
I can't view email body please help! Using Outlook 6
B help: where are outlook2000 email accounts stored Using Outlook 14
R HELP!!! Email template with active excel spreadsheet Using Outlook 1
T Need help making RULE to prepend email SUBJECT Using Outlook 3
S Help with multiple email accounts Using Outlook 5
S HELP: Email body transcript deleted when receiving response emails Outlook VBA and Custom Forms 1
D Need email verification for international emails, help? BCM (Business Contact Manager) 2
A Help creating custom Contacts form - what type is 'Email' control? Outlook VBA and Custom Forms 1
S Outlook Email Help: Select custom voting button options VBA Outlook VBA and Custom Forms 1
S HELP: Create Buttons in Outlook Email body or Tool bar Outlook VBA and Custom Forms 1
J Email body and signature help Outlook VBA and Custom Forms 4
D Script help - retain forwarded email body & location of script Outlook VBA and Custom Forms 5
L Send reply when email is sent HELP! Outlook VBA and Custom Forms 2
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 2
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
A Search folder and move the email Outlook VBA and Custom Forms 0
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
D Delete selected text in outgoing email body Outlook VBA and Custom Forms 0
F Graphics in email / Mac recipient garbled Using Outlook 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
G Print email attachments when hit subfolder Outlook VBA and Custom Forms 1
C Spam Email? Using Outlook 2
G Automatically delete email when a condition is met Outlook VBA and Custom Forms 1
E Save Selected Email Message as .msg File - digitally sign email doesn't works Outlook VBA and Custom Forms 1
S Email was migrated from GoDaddy to Microsoft exchange. We lost IMAP ability Exchange Server Administration 1
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
S Paperclip icon shows without attachment in email under Sent folder Using Outlook 0
B Outlook 2019 Automatically move email after assigning category Using Outlook 4
Rupert Dragwater How to permanently remove an email address Using Outlook 9
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
F Want to add second email to Outlook for business use Using Outlook 4

Similar threads

Back
Top