Hi DH,
this code is only slightly different compared to the marksnow version, so we may have used the same source. We use it for several months by now to create and send reports in .pdf format to different people with a single button click.
Option Explicit
'Declare public object variables...
Hi Mark,
I have a small msaccess application running, where I generate a .pdf file, based on a msaccess offer report. The .pdf file is used to send as attachment on a lotus notes mail to selected customer(s).
I don't know if you already found a solution, but if you are still interested I can...
Hi there,
this is the basic version of the function I use to fill mails with access database information and send it with lotus notes.
Public Function sendMail()
Dim MailDb, MailDoc, Session As Object
Dim MailDbName, Bodytext, Subject, Recipient As String
' set subject title using...
I'm using an msaccess database application to mail a list with lotus notes.
The list is generated in msaccess and imported as a string into the body text of the mail itself.
Works great but to make the content very clear I would like to set the font type of that LN body text as a monospaced type...
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.