Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    126

    Unanswered: DoCmd.SendObject & Selecting eMail Acct.

    I have two questions.
    First - In Oulook I have 4 accounts. I want the SendObject email to be sent from an account other than the default. I don't see how to do this in the SendObject method.
    Second - To be sent is a formated summary of a client's status for them to review and return with corrections, if any. The summary is an Access Report that is snail-mailed and is fairly lengthy. Since it has to be editable by the client for return, which would be better a) to create the report in rtf to use as the acSendReport, "reportname", acFormatRTF or b) to put the info (or the report itself) in the Message field, or c) to send the report as an attachment? I'd really like to use the report as it if possible.
    Pete T.
    PGT

  2. #2
    Join Date
    Apr 2011
    Posts
    23
    Limitations of the SendObject Command
    While the SendObject command is useful for sending an object or short message, it has several significant limitations:

    Messages must be 255 characters or less
    Messages are plain text and cannot be HTML format
    Cannot attach multiple files (limited to one attachment)
    Cannot attach a file on disk
    Cannot filter the data source or report to just the data you need to send
    Cannot specify the FROM address
    Cannot specify settings such as priority, sensitivity, and read receipt
    MAPI security dialog box prompts the user for each email to verify it is okay to send
    Doesn't always work with email programs if it's not Outlook, Outlook Express, or Exchange

    info from - SendObject Method in Microsoft Access: Features and Limitations for Sending Emails via DoCmd.SendObject

    Report in rtf would probably be your best bet with the limitations.

    I have seen a couple of posts on here listing code including
    Code:
    Set objOutlook = CreateObject("Outlook.Application")
       Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
       With objOutlookMsg
          Set objOutlookRecip = .Recipients.Add("STAFFNAME")
          objOutlookRecip.Type = olTo
    which may be the answer your looking for (I unfortunately didnt have much success with it though)

  3. #3
    Join Date
    Nov 2011
    Posts
    413

    I use this myself as an event procedure on form

    DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [E Mail], , , , "From Gulf Coast Electric", True, ""

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •