LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving email attachments Dixon7 Excel Discussion (Misc queries) 8 July 8th 09 05:43 PM
Email With attachments Twisty1980 Excel Discussion (Misc queries) 1 May 19th 08 05:18 PM
Email attachments Holden Caulfield New Users to Excel 1 April 20th 07 02:00 AM
array for email attachments? joox Excel Programming 3 May 25th 05 05:59 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"