I need to attach a text file with my email using Access97. Without attaching the text file, the message goes thru okay, and I can retrieve my new message from Outlook.
Here is my statement
DoCmd.SendObject acSendModule, "Mytextfile.txt", acFormatTXT, "Mr. Bob", , , "This is the subject", "This is the message!", False
I get run-time error 2501 ... the SendObject action was cancelled. I tried the full path name of the text file
"c:\temp\Mytextfile.txt"........ still same error
How can I attach a text file..... which is not an object in my current database?
I selected the acSendModule option b'cos that was what appeared closest to a text file.
Any help?
acSendForm
acSendModule
acSendNoObject (default)
acSendQuery
acSendReport
acSendTable
Here is my statement
DoCmd.SendObject acSendModule, "Mytextfile.txt", acFormatTXT, "Mr. Bob", , , "This is the subject", "This is the message!", False
I get run-time error 2501 ... the SendObject action was cancelled. I tried the full path name of the text file
"c:\temp\Mytextfile.txt"........ still same error
How can I attach a text file..... which is not an object in my current database?
I selected the acSendModule option b'cos that was what appeared closest to a text file.
Any help?
acSendForm
acSendModule
acSendNoObject (default)
acSendQuery
acSendReport
acSendTable