Sending mails from MS outlook

Ananthan
Lounger
Posts: 26
Joined: 23 Apr 2014, 06:05

Sending mails from MS outlook

Post by Ananthan »

Dear Team,

I need a macro, in which we can send mails which includes an attachment , if the size is limited to 1MB , auotomatically zips the file & send to the specific mail id mentioned. Based on the deatils in an excel file.

The Message will be common & the attachment will be seperate.

Regards
Ananthan

User avatar
HansV
Administrator
Posts: 78642
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sending mails from MS outlook

Post by HansV »

See Mail from Excel with Outlook (Windows) for lots of sample code.
Best wishes,
Hans