SendObject and filenames

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Lauren Quantrell

    SendObject and filenames

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

    DoCmd.SendObjec t acSendReport, "myReportNa me", 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
  • Lauren Quantrell

    #2
    Re: SendObject and filenames

    I answered my own question. The Form.Caption property is the filename.
    lq

    laurenquantrell @hotmail.com (Lauren Quantrell) wrote in message news:<47e5bd72. 0404010759.26c9 26c2@posting.go ogle.com>...[color=blue]
    > I am using the following to attach a report, in HTML format to an
    > e-mail using Access2K:
    >
    > DoCmd.SendObjec t acSendReport, "myReportNa me", 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[/color]

    Comment

    Working...