CDO attachment question

[austin350s10]

Is there any way in the world to send an attachment using CDO with the attachment as a variable instead of the full file path?

My problem is that where I am using my save-and-mail script the users machines will not allow them to save a file on the C:\ drive but that is the only place I can think of that would be the same on all computers. Maybe there is a file path that is more accessible than the root C:\ drive. Any ideas?

Right now I have a beautiful script that saves the active sheet to the desktop of any machine but it only has the ability to save the file path as a variable which is why I really want to find a way to send an attachment as a variable but it has to be done using CDO not Outlook or any other email client.

My understanding is that this cannot be done but I am wondering if anyone knows about a work around??

 

[doofusboy]

that is the only place I can think of that would be the same on all computers

Assuming all your users are using the Windows OS, you could try something like this:

ChDir ("C:\Documents and Settings\" & Application.UserName & "\Local Settings\Temp")

as all should have this temporary directory.

 

[austin350s10]

works perfect thanks!!!