Schedule macro and then e-mail report?

[bowes884]

Ok. I have a schedule right now that automatically runs my macro I need and sends the report to a certain file. Is there anyway that I could extend this to copy the report and paste it onto an e-mail in Lotus Notes and then send the e-mail? Just trying to eliminate a tedious hourly task.

Bowes

 

[Jibbadiah]

Have you taken a look at the SendObject action within Macros? Don't know if it will work with Lotus Notes, but using this action allows you to automatically send an email with a report attached.

 

[bowes884]

I looked through Lotus Notes and didn't even find the Macro menu for it. As far as an attachment, The people that these e-mails are going to are real busy. The report I send them is a reminder to look at it even though they could just pull it up if they remember. Thats why I would rather copy and paste it than attach it.

Bowes

 

[Jibbadiah]

I meant an access macro. It has a sendobject action that allows you to attach a file and send it automatically.... still not quite sure that it is what you are after. I believe that this macro always sends as an attachment - Still, put it in html format and they only have to double-click.

 

[Jibbadiah]

Take a look at the following... it might be more helpful than what I have already said.

http://www.access-programmers.co.uk/forums/showthread.php?p=388787#post388787