How to send email from excel vba in outlook

[aryan]

Hi Team,

Please help in assisting how to send email in outlook through excel vba.

Regards
Aryan

 

[sasuke]

I want to know this too

 

[Jigar B]

Upload a sample excel file and same outlook email you want to draft using that excel file.
Outlook version?

 

[Stevie]

I modified some of the code from here:
http://www.rondebruin.nl/win/s1/outlook/mail.htm
for a previous project.

I believe it requires outlook to be open, and you have to enable a trust centre setting in outlook to 'allow programmatic access'.

 

[aryan]

Hi Jigar B,

Please find attached the sample file for sending the email through outlook.
outlook version is 7

Regards
Aryan

 

[Jigar B]

Hi,

Please find the attached file. I have changed the columns so that macro can work perfectly. You can have as many rows you want in distribution list and it will prepare the outlook email for each row. You can change the subject and mail body in second sheet as per your requirement.

Currently this macro is giving you the new emails created for each row. If you want to send the email directly, you can edit the code by commenting following line in code:

.Display

and uncommenting following line in code:

.Send

Note: Please DO NOT change sheet name and order of columns.

 

[aryan]

Thanks Jigar I will check and revert to you for any query.
Many Many thanks to you.

 

[aryan]

Hi Jigar, it is showing error in below code, (olMailItem) error library cannot find it. cannot execute code in break mode.

Please assist here.

Regards
Aryan

 

[Jigar B]

Sorry I missed to write a note to you. In macro editor screen goto "Tools" >> "References" and put a tick against "Microsoft Outlook 15.0 Object Library".
15.0 can be any version.

 

[aryan]

Hi Jigar,

First of all i would like to say thanks to you that it is working fine.
Thanks for the support.

I have some queries.

1) By this tracker I am sending email to only a new email.
--can I reply on previous email reply through this email . for example I get a email and want to reply through this email tracker on the same email.
Is is possible?

2) I want to add a third sheet on which my replies on that sheet latest reply on top then previous one for example-- like time and date wise as data in the first in tracker automatically added in a sheet.email distribution added in new sheet.

3/Is it possible to add attachment though VBA tracker.
4)Can I have more option for email body template.

for example I have more template but after clicking that particular template it goes that particular template.

Thanks in Advance.
Aryan