Auto Emailing

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

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:="[email protected]", _
Subject:="Email heading " & Format(Date - 1, "dd/mm/yyyy")
End Sub

The will send the workbook to the person you choose.

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