472,119 Members | 1,808 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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 1382
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.