Do you have Root Access to the C drive. Translation... Try saving something
into the root of your C drive. Very often administrators lock that down for
you to keep you form messing with systme files and the like...

HTH

"Mark Scott" wrote:

Thanks Jim, it still doesnt want to play though :(

"Jim Thomlinson" wrote in message
...
Your path is not correct. You have C: forward slash not c: Back slach
change

C:/

to

C:\

HTH
"Jim Thomlinson" wrote:

What line do you get the 1004 error on?

"Mark Scott" wrote:

I have been asked to look at a form in Excel which is automatically
sent to
an email address depending on the data it contains. I have used a
listbox
and a combination of IF and CONCATENATE to make the email address.

What I need to do now is to send this sheet as an attachment in Outlook
(Exchange 2003). I would like the macro ro reference an email address
in
the worksheet - save a worksheet to a secified location then sent it
via
Outlook as an attachment to the address referenced.

Any clues or ideas?

Regards

Mark