var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Vba email multiple attachments
I am stuck and would appreciate any help.
I working in Access 2010 and have the following code.
And draws the following from a memo field type in the table: "S:\folder\filename1.pdf”; "S:\folder\filename2.pdf”; "S:\folder\filename3.pdf”.
.attachments.Add ((DLookup("Attachment", "tblemailmessageattachments", "Location = '" & Forms![frm1]![LOC] & "' And Emptype = '" & Forms![frm1]![EmpType] & "'")))
The problem is I only the first document attaches.
I'm going nuts with this.
DLookup() can only return one value, whatever the number of matching rows can be.
Have a nice day!