Auto Emailing

tek9step · #1 06-29-2009, 06:14 AM

Hello Is there a way where by i can set auto email sent out on a monthly basis to a particular email.

Thanks

Regards

Tek9Step

famico78 · #2 06-29-2009, 06:34 AM

Hi

I'm not sure how your sheet is set up but you can create a new module with the following..

Sub email()
ActiveWorkbook.SendMail _
Recipients:="your.choice@particularemail.com", _
Subject:="Email heading " & Format(Date - 1, "dd/mm/yyyy")
End Sub

The will send the workbook to the person you choose.

tek9step · #3 06-29-2009, 06:48 AM

Hi I was thinkin more on the lines from Microsoft outlook if i do it from excel vb i would have to open it manually and send it..

Regards

Tek9Step

Welcome to the Excel Forum

Forum Statistics