Auto-send email and auto back up at specific time

[gregorys714]

Hi,

I am trying to create an automated report to be sent out as an email.

I need a email created and cells B6:S8 copied into a table and the email automatically sent from a PC.

I already have a Macro to take a back up of the information in cells B8:S8 and paste it into the next available row but I need this to auto run at the same time as the email, (7am and 7 pm)

Any help is greatly appropriated

 

[pbornemeier]

This site has many options for controlling Outlook from Excel: Mail from Excel with Outlook (VBA)