Juan Velasquez
asked on
Sending query results to Lotus Notes from Access
Hello,
I have a query in a Access 2007 database, whose results I wish to send to lotus notes as an attachment. I've verified that the lotus notes references are set. I need some help in how to best export the query results to lotus notes. There is a method called docmd.send object that I think I could use. I would appreciate any help
I have a query in a Access 2007 database, whose results I wish to send to lotus notes as an attachment. I've verified that the lotus notes references are set. I need some help in how to best export the query results to lotus notes. There is a method called docmd.send object that I think I could use. I would appreciate any help
There are hundreds of pages explaining how to send a mail through Notes, with an attachment. In most cases, the attachment has to be created first, as a file.
Here's an example:
- http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
Here's an example:
- http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For an example with a rich text Body field:
- http://www.accessmonster.com/Uwe/Forum.aspx/access/92210/send-email-in-lotus-notes-from-access
- http://www.accessmonster.com/Uwe/Forum.aspx/access/92210/send-email-in-lotus-notes-from-access
ASKER
I found I had to comment it out to make it work.
Open in new window