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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining data with the same ID and the similar variables 1
Make all variable values in a Array equal to 0 8
Using only variables to reference a range 2
Sending Mail programatically 1
Setting up an incremented Variable name 2
VBA - Function Output 2
Data passing betw ASP & ASPX pages 2
multiple dependent drop down lists 6

Back
Top