Experience commanding Lotus Notes from Access?

[jpalmer150]

I'd like to schedule Access to create a report and send to it a specific email address. Using the SendObject command I can get Access to create the email with the attachment but it doesn't populate the TO: field and it doesn't attempt to send.

Does anyone have experience commanding Lotus note email from Access?

 

[PHV]

You may consider the DoCmd.OutputTo method to generate the report in rtf and then play with a lotus session object:

http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[jujubee66]

I've researched this and need it for a project that I am developing as well.....Isn't there a way to send an object within Access (ie. query, report) to a Lotus Notes email address automatically without having to save it on your hard drive and then use the EMBEDOBJECT method.

Thanks for your help.

 

[GComyn]

Here is a thread that will show how to send emails through lotus notes from access.

With this one, you do need to have files already created to send them as attachments.

I don't know of anyway to send a query or report directly to an email program without first saving it as a file.

Here is the thread:

thread222-38494

GComyn