Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Send email from Access (2003)

    Hi,

    I am using the attached SendMail codes from Hans in my Access database to convert report to a pdf file and then attach a new mail as attachement.

    I would like to know if I can update it to have outlook send me a receipt emai, mark it as important and turn flag for follow up for due by 3 days later.

    SendMail "to@to.com", "cc@cc.com", "", strTopic, strMBody, strPDFFile, ShowMail:=True

    Thanks in advance.

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send email from Access (2003)

    These are Outlook questions, not Access questions.

    Please look up the MailItem object in the Outlook VBA help. There are properties for these settings. In your code, you'd set these properties for the objMI object before displaying or sending it.

    For example, you can set

    .ReadReceiptRequested = True
    .Importance = olImportanceHigh
    .FlagStatus = olFlagMarked
    .FlagDueBy = Date + 3

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send email from Access (2003)

    Thanks, Hans.

    After I apply the codes, is those seting going to affect to all the email that I send from Outlook or just only the email I open from Access database?

    Thanks

    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send email from Access (2003)

    The settings I mentioned in my previous reply only apply to the e-mail being created by the code, not to Outlook in general.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send email from Access (2003)

    Thanks, Hans.

    Is there anyway to auto open the "To" box as a new email open?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send email from Access (2003)

    Sorry, I don't understand your question.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send email from Access (2003)

    I would like to know if I can update it to have outlook have "To" box open, so user can type name and select from Global Address List.

    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send email from Access (2003)

    The user can click on To... or press Alt+. to open the dialog. I would find it irritating if the dialog was displayed automatically. But if you really want to do it, you might add a line
    <code>
    SendKeys "%."
    </code>
    below the line with .Display.

  9. #9
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send email from Access (2003)

    Thanks, Hans.

Posting Permissions

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