attachments for emails

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi

I am using outlook to send an email from Access

I have got the full qualified filename into variables eg var1 var 2 var 3

Using variable 'attachfile' I have set attachfile = var1 & var2 & var3

I then use Set objOutlookAttach = .Attachments.add(attachfile)

My problem is that only the first file is being attached

Can some kind person tell me what I am doing wrong please?

tks

A
 
Not positive, but I believe you need to use

Set objOutlookAttach = .Attachments.add(var1)
Set objOutlookAttach = .Attachments.add(var2)
Set objOutlookAttach = .Attachments.add(var3)
 
Back
Top