Send MS Access report to Lotus Notes 1

[rexxxy]

I would appreciate any help available on this one.

I have been asked to investegate weather or not it is possible to utilise the functionality within Microsoft Access to email an object output (in this case a report). So user runs a report and then exports that data into an email in Lotus Notes.

I will post the same request for assistance in an MS Access forum.

thankyou for looking.

 

[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 or FAQ222-2244