Interfacing to Outlook

L

Leon Hairie

I am trying to send a email with an Excel attachment from Access but every
time that I reach the .Add method Access/Outlook reports that it cannot find
the file.

Can anyone tell me what gives.

I apologies for being off topic if this in not the right forum





Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.Subject = mysubject
.Body = "Please Read Documents"
.To = rs!Display_name

'----------------System cannot find the file specified----------

.Attachments.Add "C:\Temp\MYFILE.XLS", olByValue, 1, "Whatever"

'--------------------------------------
.Send

End With
 

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

Using Word VBA to send emails not working 0
Specify Font Name or Face using VBA Macro in Word 2
Need help writing VBA module 0
Can I specify font for body content of email using vba macro. 1
How to set the order of attachments in outlook message 3
command button to send mail 2
Send Saved Word Doc as attachment to fixed email address 0
Send Email From Word 0

Top