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

Hi

No luck with this that I suggested in your other thread

olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ir26121973" <[email protected]> wrote in message news:[email protected]...
> 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

Ron,

I'm so very sorrry, I hadn't seen this in my other thread, it works a treat.

Sorry to have wasted your time.

Thanks a million....once again

Kind regards

Chris
"Ron de Bruin" wrote:

> Hi
>
> No luck with this that I suggested in your other thread
>
> olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls"
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "ir26121973" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

> I'm so very sorrry, I hadn't seen this in my other thread, it works a treat.

No problem
It was a long thread <g>

Have a nice day


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ir26121973" <[email protected]> wrote in message news:[email protected]...
> Ron,
>
> I'm so very sorrry, I hadn't seen this in my other thread, it works a treat.
>
> Sorry to have wasted your time.
>
> Thanks a million....once again
>
> Kind regards
>
> Chris
> "Ron de Bruin" wrote:
>
>> Hi
>>
>> No luck with this that I suggested in your other thread
>>
>> olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls"
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "ir26121973" <[email protected]> wrote in message news:[email protected]...
>> > 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
>>
>>
>>

Cheers Ron,

Have a nice day to you also.

All the best

Chris

"Ron de Bruin" wrote:

> > I'm so very sorrry, I hadn't seen this in my other thread, it works a treat.
>
> No problem
> It was a long thread <g>
>
> Have a nice day
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "ir26121973" <[email protected]> wrote in message news:[email protected]...
> > Ron,
> >
> > I'm so very sorrry, I hadn't seen this in my other thread, it works a treat.
> >
> > Sorry to have wasted your time.
> >
> > Thanks a million....once again
> >
> > Kind regards
> >
> > Chris
> > "Ron de Bruin" wrote:
> >
> >> Hi
> >>
> >> No luck with this that I suggested in your other thread
> >>
> >> olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls"
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "ir26121973" <[email protected]> wrote in message news:[email protected]...
> >> > 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
> >>
> >>
> >>
>
>
>