View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ir26121973 ir26121973 is offline
external usenet poster
 
Posts: 45
Default Saving email attachments

Hi,

Wonder if someone can help me please.

I have a macro that looks for emails containing a certain word in the
subject line. It takes the attachments from those emails, copies them and
pastes them in a shared C Drive folder.

To save the attachments I am using the filesize as a unique filename.
However the problem is that when there are two files with the same file size,
one overwrites the other.

I know I can use the subject line in it's entirety but the subject line is
too long. There is however a unique number within each file that starts with
":File then 5 different digits".

Does anyone know please whether I can use just this part of the subject line
within to use to save the file or perhaps something else.

I'm sorry to go on a bit but I thought I needed to explain the whole problem.

Regards

Chris