I am running Windows 7 (64bit) and Office 2010
I have a database that creates a pdf document on disk and a button that calls my email program, attaches the docuemnt and leaves the new email open for edit. The code is:
stEmail = Me.Parent!Email
stFileName = "D:\documents\abc_" & Me.varNumber & ".pdf"
DoCmd.OutputTo acReport, stDocName, acFormatPDF, stFileName
DoCmd.SendObject acSendReport, stDocName, acFormatPDF, stEmail
This used to work. Now it creates the pdf but displays an Access message that "it can't send this email message"
I can replace the "SendObject" line with:
Application.FollowHyperlink "mailto:" & stEmail
This calls the email program correctly.
By default I use Thunderbird but I changed to Outlook and the same problem occurs, so, it appears to be an Access problem.
It is the "SendObject" line that casues the problem.
Has an Access update broken the system?
Please Help!
I have a database that creates a pdf document on disk and a button that calls my email program, attaches the docuemnt and leaves the new email open for edit. The code is:
stEmail = Me.Parent!Email
stFileName = "D:\documents\abc_" & Me.varNumber & ".pdf"
DoCmd.OutputTo acReport, stDocName, acFormatPDF, stFileName
DoCmd.SendObject acSendReport, stDocName, acFormatPDF, stEmail
This used to work. Now it creates the pdf but displays an Access message that "it can't send this email message"
I can replace the "SendObject" line with:
Application.FollowHyperlink "mailto:" & stEmail
This calls the email program correctly.
By default I use Thunderbird but I changed to Outlook and the same problem occurs, so, it appears to be an Access problem.
It is the "SendObject" line that casues the problem.
Has an Access update broken the system?
Please Help!