Another Outlook question

F

ForSale

when sending an e-mail from outlook, i know how to attach the curren
workbook, how can i change that to attach a different workbook?
i would think that i would need to change this line:
.Attachments.Add ActiveWorkbook.FullName
thanks
 
B

Bob Phillips

It would help to see your code. It should look something like

Attachments.Add "C:\myDir\myFile.xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

ForSale

the code in question is :
attachments.add "w:\Daily Group Summary Reports\Team 55 I
Lastname.xls"
the file name varies, but the folder and drive are constant.
sometimes it works if i just save the file to the w: and leave off th
folder name, but that is rather inconvenient
 
B

Bob Phillips

Whilst there is an extra dot in the filename that shouldn't cause a problem.
Does the file actually exist?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

ForSale

Yes, the file exists, in fact, a few chapters earlier in the same modul
is a 'save as' that makes it save it as that same name
 
Top