469,625 Members | 1,059 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

SendObject and filenames

I am using the following to attach a report, in HTML format to an
e-mail using Access2K:

DoCmd.SendObject acSendReport, "myReportName", acFormatHTML, , , ,
"mySubject", "myTExtBody", True, "myTemplateName"

However, when the e-mail is created, the attachment is named
"Users.HTML"

How can I change it?
Any help is appreciated.
lq
Nov 12 '05 #1
1 1301
I answered my own question. The Form.Caption property is the filename.
lq

la*************@hotmail.com (Lauren Quantrell) wrote in message news:<47**************************@posting.google. com>...
I am using the following to attach a report, in HTML format to an
e-mail using Access2K:

DoCmd.SendObject acSendReport, "myReportName", acFormatHTML, , , ,
"mySubject", "myTExtBody", True, "myTemplateName"

However, when the e-mail is created, the attachment is named
"Users.HTML"

How can I change it?
Any help is appreciated.
lq

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.