E-mailing a Snapshot Report

[Guest]

Hi

I have set up code to run a report and output it to snapshot format then
send it via e-mail.

All this works fine except that I still need to click send on the e-mail
then do a send and receive in Outlook.

Is there any way to automatically click the send button and also hopefully
do te Outlook send & receive.

Thanks in advance for any help

 

[Rick B]

I believe one of the options in the SEND command in vba is something like
"edit". Changing this parameter in your statement will send the email (at
least put it in the outbox) without you clicking send. Your Outlook
settings can be used to have it send every X minutes.

Read the vb help file for the full parameters.