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

--
Message posted from http://www.ExcelForum.com

nevermind, i just look at ron's site. thanks thoug

--
Message posted from http://www.ExcelForum.com

Okay, now i have another question.
i used the example at http://www.rondebruin.nl/mail/folder2/mail1.htm
but i can't seem to get it to work. i keep gettin the followin
error:
Run-time error '-10544742 (f9b70002)':
Can't find this file. Make sure the path and file name are correct.

any thoughts

--
Message posted from http://www.ExcelForum.com

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)

"ForSale " wrote in message
...
Okay, now i have another question.
i used the example at http://www.rondebruin.nl/mail/folder2/mail1.htm
but i can't seem to get it to work. i keep gettin the following
error:
Run-time error '-10544742 (f9b70002)':
Can't find this file. Make sure the path and file name are correct.

any thoughts?


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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)

"ForSale " wrote in message
...
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 the
folder name, but that is rather inconvenient.


---
Message posted from http://www.ExcelForum.com/