Email via Lotus Notes the results of a query.

[fishy]

I have a various export files that goes to the same recipients daily.

Currently i have a scheduled task that exports the files as .xls to a
specified folder location and then I have to attach and send the various
files to the named individuals.

I know that MSAccess can run the query and send via Notes but have not got a
scooby where to start. Does anyone have an example database or has an idiot
proof code that I can adapt for my specific tables/databases/file paths etc?

Thanks in anticipation as this will save a considerable time every morning.

 

[Piet Linden]

I have a various export files that goes to the same recipients daily.

Currently i have a scheduled task that exports the files as .xls to a
specified folder location and then I have to attach and send the various
files to the named individuals.

I know that MSAccess can run the query and send via Notes but have not got a
scooby where to start. Does anyone have an example database or has an idiot
proof code that I can adapt for my specific tables/databases/file paths etc?

Thanks in anticipation as this will save a considerable time every morning.

Check out the stuff on Tony's site:
http://www.granite.ab.ca/access/email/lotusnotessample.htm