INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Save attachments from Outlook

Save attachments from Outlook

(OP)
I am working with some code that saves the attachments on selected emails...

It saves out the first attachment, and then the next attachment has the file name + a formatted date trailing on the name...
It does this because the attachments are all named the same thing.

I don't want it to name the files like that - I want it to save the first attachment, and for the rest, add 1 to the file name..
So -
savedattachment.csv
savedattachment_1.csv
savedattachment_2.csv
savedattachment_3.csv
And so on...

Below is what I am working on:

Do While objFSO.FileExists(strAtmtPath)
strAtmtNameTemp = strAtmtName(0) & _
Format(Now, "_mmddhhmmss") & _
Format(Timer * 1000 Mod 1000, "000") + 1
[/b]

'CMS Daily New Seminar Reports_0223130204477

strAtmtPath = strFolderPath & strAtmtNameTemp & "." & strAtmtName(1)

' /* If the length of the saving path is over 260 characters.*/
If Len(strAtmtPath) > MAX_PATH Then
lCountEachItem = lCountEachItem - 1
' False: This attachment cannot be saved.
blnIsSave = False
Exit Do
End If
Loop

RE: Save attachments from Outlook

Hi,

CODE

'
   Dim i as Integer
'...
   i = 0
   Do While objFSO.FileExists(strAtmtPath)
      If i = 0 then
         strAtmtNameTemp = strAtmtName(0)
      Else
         strAtmtNameTemp = strAtmtName(0) & "_" & i
      End if
'....
      i = i + 1
   Loop 

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close