How Can I attach multiple PDF file using below code?

[Ashfaque]

Gents,

I am using following code and it successfully attach my report in email. But I need to add another pdf file along with in same email.

Dim strMailList, StrCC As String

strMailList = CEmail
StrCC = "xyz@gmail.com"

DoCmd.SendObject acSendReport, "R_JobOffer", acFormatPDF, strMailList, StrCC, , "JOB OFFER LETTER - " & LetterRefNumber & _
" - " & CName & " - " & Format(Now()), "Dear " & CName & "," & vbCr & vbCr & "With reference to our discussion during " & _
"interview and according to your qualification, we are pleased to offer you an employment at our International Agent Company." & _
" We feel your skills and experience will be valuable assets to our team." & vbCr & vbCr & "If you choose to " & _
"accept this offer, please sign and re-send back to us as your acceptance." & vbCr & vbCr & "Good Luck and Best Regards," & _
vbCr & vbCr & "Sincerely," & vbCr & vbCr & "Brian Clark" & vbCr & "Human Resources Dept.", True

The primary key is set on field LetterRefNumber where all the data of R_JobOffer and the additional pdf file which I want to attached in email are in one table called. T_JobOffer. But some other data are coming from another table called T_JD_Footer.

In other words, both table T_JobOffer and T_JD_Footer are in one to many relationship set on LetterRefNumber.

Is there any chance to know if it is possible?

Kindly support.
Regards,
Ashfaque

 

[Gasman]

I do not believe you can.?
You need to use Outlook automation.?

 

[Dreamweaver]

The only way maybe to add them all to a zip file the alter acFormatPDF I've never done it but should work

History | Ron de Bruin

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

VBA code to Zip and Unzip files and folders - Excel Off The Grid

Recently, I have been working on a project which requires the zipping and unzipping files and folders. Zip files are now a common method of compressing files

exceloffthegrid.com

 

[Isaac]

The VBA you are using automates Outlook behind the scenes anyway, you might as well switch to Outlook automation as Gasman mentioned and you could attach as many pdfs as you like.

 

[Dreamweaver]

If you want to/can go the outlook way then this may help
Import/Export outlook contacts and more