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
 
D

Dmitry Streblechenko

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
 
S

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

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

>

>
>> .
> >
 
S

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

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

>

>
>> .
> >
 
S

sam

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
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
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
F Forward incoming email with 4 embedded images in the body without original sender Outlook VBA and Custom Forms 22
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
C Outlook 2007 Removing then adding account restores junk email processing Using Outlook 0
G Place jpg in body of email Outlook VBA and Custom Forms 1
F Wishlist Outlook suddenly began synchronizing deleted items every time I delete a single email. Using Outlook 2
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
HarvMan Toggle between calendar and email in Outlook 365 Using Outlook 12
F Email being marked as Spam by Gmail and not being visible in Outlook Using Outlook 5
G Email time stamp Using Outlook 2
G Schedule recurring email and attachments display Outlook VBA and Custom Forms 3
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
M How to setup outlook after importing old account information - Entering email account info creates with "(1)" after the account! Using Outlook 1
K Multiple Rules on Single Email Using Outlook 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
e_a_g_l_e_p_i Outlook 2010 How to set default email address for website links Using Outlook 3
O Same email address, same person, names in so many ways Using Outlook 4
D Create new email from the received Email Body with attachment Outlook VBA and Custom Forms 10
D Outlook launch email showing new unread email in reading pane Using Outlook 11
B Zoom automatically next email item (VBA) Outlook VBA and Custom Forms 2
K Outlook adds space to rows in HTML email signatures viewed on mobile Using Outlook 1
M HTML email signature in Outlook Using Outlook 3
M Respond to Outlook Email Outlook VBA and Custom Forms 0
U Outlook locking up when replying to Email Using Outlook 7
S Email Generated from another program and then edited sends original email. Using Outlook 2

Similar threads

Top