save attachment with date & time mentioned inside the file

subhas

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Office 365 Exchange
Dear all,

I need to save the file with specific date & time mentioned inside the txt file
I am using the below code to save the file into my drive but want to accomplish different naming method
Want to consider the file name as "12-01-21_08:09:08" which is mentioned at right corner as Date & time inside the txt file (attached)

Date & time is given like below in txt file

Date 12-Jan-2021
Time 08:09:08 (EST)

want the file name as below date 12-01-21 & time 08:09:08 combined like like (dd-mm-yy_hh:mm:ss)

12-01-21_08:09:08

1610461755232.png


code modification required to get the file name as desired
-----------------
Sub saveAttachZFI2B047(itm As Outlook.MailItem)
Dim objAtt As Outlook.Attachment

Dim saveFolder As String
Dim mydate As String

mydate = Format(Date, "yymmdd")

saveFolder = "C:\Users\\Documents\ZFI2B047"
For Each objAtt In itm.Attachments
objAtt.SaveAsFile saveFolder & mydate & objAtt.DisplayName
Set objAtt = Nothing
Next
End Sub

----------
I have attached my example file, this is to make files saved as per SAP job date & time which is my requirement. Pls some one see if this can be accomplished. Thank you

regards
subhash
 

Attachments

  • 210112PR2 IBDX 20210112130908.txt
    4.6 KB · Views: 5
Similar threads
Thread starter Title Forum Replies Date
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
peacepanda How to save attachment looking at the attachment name Outlook VBA and Custom Forms 1
D Automatically save attachment to network folder Exchange Server Administration 1
C How To Open Outlook Attachment in Excel, Modify some Data, then Re-Save It Using Outlook 3
J Save attachment if email is from joe Outlook VBA and Custom Forms 4
H Save .msg attachment as .rtf Outlook VBA and Custom Forms 10
E Auto Save Zip File Attachment to Network Folder Outlook VBA and Custom Forms 1
S unable to save attachment Outlook VBA and Custom Forms 1
S save attachment using outlook 2007 Outlook VBA and Custom Forms 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 2
S Add VBA save code Using Outlook 0
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
W Outlook Calendar does not save view any longer! Using Outlook 3
S automate save the .xlxs file to share Network Using Outlook 1
S save email from excel Outlook VBA and Custom Forms 1
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
R VBA | Chosing path to save file Outlook VBA and Custom Forms 1
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
V Change default default save location to Quick Access Using Outlook 1
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
C Outlook - cannot save subject line changes Using Outlook 2
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
N editing drafts - won't let me save Using Outlook 12
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
D Save Sent Item to Using Outlook 0
Diane Poremsky Save Selected Email Message as .msg File New Slipstick.com Articles 11
Diane Poremsky Export (Save) Outlook Contact photos New Slipstick.com Articles 0
Diane Poremsky Save Messages and Attachments to a New Folder New Slipstick.com Articles 0
B Delete/replace old files and save new attachments Using Outlook 1
E Outlook 2016 and Numerous Prompts to Save Emails Using Outlook 3
Diane Poremsky Save Outlook Email as a PDF New Slipstick.com Articles 0
Diane Poremsky Edit and Save Outlook's Read-Only Attachments New Slipstick.com Articles 0
Diane Poremsky Save Attachments to the Hard Drive New Slipstick.com Articles 2
C Save Subject of Received Email as a String Outlook VBA and Custom Forms 1
C Rule To Save attachments on receipt of email Outlook VBA and Custom Forms 2

Similar threads

Top