Results 1 to 4 of 4
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have an access app that is set to automatically send emails with attchments.
    Works fine.

    BUT

    Now I need to either send, or invoke Outlook app,
    with the email Ready to Send

    How can I show the email Item, OR would I be beter off,
    using DoCmd.SendObject when I want th allow the user to Edit or Add Recipients.

    Existing Code is...


    Set objItem = objOut.CreateItem(0)

    With objItem
    .To = strTo
    .Subject = strSubject
    .Body = strBody
    .Attachments.Add strPath & strFile
    If fSendOthers = False Then
    .Send
    Else
    'Need to show Mail Item here

    End If
    DoEvents
    End With
    Andrew

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    To show the e-mail message you can use its Display method:

    Code:
    If fSendOthers = False Then
      .Send
    Else
      'Need to show Mail Item here
      .Display
    End If

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    would I be beter off,
    using DoCmd.SendObject when I want th allow the user to Edit or Add Recipients.
    Further to Hans reply, SendObject does not support attachments, other than database objects (e.g. reports) so it is unlikely that this will do what you want.
    Regards
    John



  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    [quote name='johnhutchison' post='785400' date='20-Jul-2009 13:53']Further to Hans reply, SendObject does not support attachments, other than database objects (e.g. reports) so it is unlikely that this will do what you want.[/quote]

    Yep realised that after I had posted the message.

    But gone with .Display option

    Thanks
    Andrew

Posting Permissions

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