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
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