Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Unanswered: Vba email multiple attachments

    Hi All,

    I am stuck and would appreciate any help.

    I working in Access 2010 and have the following code.
    Code:
     .attachments.Add ((DLookup("Attachment", "tblemailmessageattachments", "Location = '" & Forms![frm1]![LOC] & "' And Emptype = '" & Forms![frm1]![EmpType] & "'")))
    And draws the following from a memo field type in the table: "S:\folder\filename1.pdf”; "S:\folder\filename2.pdf”; "S:\folder\filename3.pdf”.

    The problem is I only the first document attaches.

    I'm going nuts with this.

    Cheers
    J

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    DLookup() can only return one value, whatever the number of matching rows can be.
    Have a nice day!

Posting Permissions

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