attachments for emails

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
 
D

Douglas J. Steele

Not positive, but I believe you need to use

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