Hi everyone, my first post here,

I am creating an e-mail using the CDO object and using the AddAttachment method to attach a file from a URL. I am having a problem in that the file file attached is given a random name (something along the lines of ATXX412.pdf).

Does anyone know if it is possible to rename/assign a name to attached file before the e-mail is sent?

Any help would be much appreciated.

I've sorted it now. Thanks.

I've had the same question and can't find much about it (yet). It'd be great if you could post what you did to fix or work around this problem.

Restated, my problem is that files are named one thing on the server (say, "attachment02823.txt") and I need to attach them to an email under a different name (so the email has an attachment "instructions.txt").

Physically renaming the file on the server is not ideal, since the goal of renaming the files is to avoid filename collision. Any ideas?

This is tricky but not impossible. The trick is to get hold of the bodypart object that represents the attachment and update that.

In the example below I simply add a prefix to the filename (my application required several files with identical names to be collected from different paths and emailed out).

The AddAttachment method does return a bodypart object but I find it easier to pull it from the end of the attachments collection as follows:-

.AddAttachment "file://C:\whatever\path" & fname
set iBp = iMsg.Attachments.Item (iMsg.Attachments.Count)

Once you've got the bodypart, you can update the FileName attribute of the content-disposition header field thus:-


Set Flds = iBp.Fields
Flds("urn:schemas:mailheader:content-disposition") = "attachment; filename=""Prefix_" & fname & """"
Flds.Update

That's it! Your attachment now has a new name.