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)
 

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
Sending Mail programatically 1
Setting up an incremented Variable name 2
Re: How can I read CSV file using VBA? 5
Data passing betw ASP & ASPX pages 2
multiple dependent drop down lists 6
using the FOR I = statement 1

Top