I'm not the original poster, but I have a db that I need to email reports from and we use Lotus Notes - can you post the code to use Lotus Notes...p. l. e. a. s. e.
Note: If you are attaching the results of a report to the e-mail, you must output it to a file and attach the file.
Function SendTPAEmail(strRecipient As Variant, strPath1 As String)
Dim objNotesSession As Object
Dim objNotesDatabase As Object
Dim objNotesDocument As Object
Dim strText As String
Dim strMsg As String
Dim varRecipient As Variant
Dim objAttach As Object
Dim objEmbed As Object
Set objNotesSession = CreateObject("Notes.Notessession"
Set objNotesDatabase = objNotesSession.GETDATABASE("", ""
Call objNotesDatabase.OPENMAIL
Set objNotesDocument = objNotesDatabase.CREATEDOCUMENT
strText = ""
on your form - try this - make a command button - then when the wizard starts, press cancle. Right click on the button and you shoould have three options - macro builder, expression builder, and code builder. Use code builder,. This opens the VB editor - paste your code there -in the on_click section.
PDUNCAN - MEMPHIS, TN
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.
is putting it in a mudule and calling it an either/or - I usually dont do that, but then again, I dont know much about this - except for what I have learned here!
PDUNCAN - MEMPHIS, TN
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.
makes sense to me - I have never done that, but it does seem reasonable and like the "right thing to do." If you placed this into a module named "Mail" how would you reference this module from the on_click of a command button?
PDUNCAN - MEMPHIS, TN
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.
You don't call the module itself, it is only a place to "store" code. You have to call the function or sub name, you can have a lot of functions or subs in 1 module.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.