Attaching date named files

Status
Not open for further replies.

dlynquent

New Member
Outlook version
Email Account
POP3
Hi,

Can someone please assist on how to attach a file with the date as part of it name.

Example "20150101-hello.txt" I am using Outlook 2003 or 2007. Any help would be greatly appreciated.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Will the file always be in the same folder? Will it be the newest file in the folder? There is a macro at http://www.slipstick.com/outlook/email/create-new-message-using-html-file-stationery/ that inserts the newest file in a folder.

you'd use .attachments.add sNew instead of reading it - replace the end of the last macro in the article with this -


'read html

' delete code between these lines

'Create e-mail item
Set objMail = Application.CreateItem(olMailItem)

With objMail
.attachments.add sNew
.Display
End With
End Sub
 

dlynquent

New Member
Outlook version
Email Account
POP3
Will the file always be in the same folder? Will it be the newest file in the folder? There is a macro at http://www.slipstick.com/outlook/email/create-new-message-using-html-file-stationery/ that inserts the newest file in a folder.

you'd use .attachments.add sNew instead of reading it - replace the end of the last macro in the article with this -


'read html

' delete code between these lines

'Create e-mail item
Set objMail = Application.CreateItem(olMailItem)

With objMail
.attachments.add sNew
.Display
End With
End Sub
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Shortcut for attaching the same file repeatedly Using Outlook 6
M re-Attaching PSTs after upgrade to 2016 Using Outlook 0
P Outlook Randomly Not attaching (attachment file) Using Outlook 0
L Creating a Task from Email and Attaching Original Email Outlook VBA and Custom Forms 6
D Attaching email conversations to tasks Using Outlook 2
R When attaching XLS file to email, it switches to Excel (if already opened) instead of attaching the file Using Outlook 2
D attaching a file Using Outlook 1
A Attaching mail items in Outlook 2010 Outlook VBA and Custom Forms 5
J Attaching Files to Outlook Outlook VBA and Custom Forms 1
D Tab Order Out of Sequence After Attaching Document Outlook VBA and Custom Forms 1
H attaching e-mails to new e-mail using VBA Outlook VBA and Custom Forms 1
witzker Pls help to change the code for inserting date in Ol contact body Outlook VBA and Custom Forms 5
C Outlook with Office365 - search across account, by date rate, in multiple folders - how? Using Outlook 2
M Sorting by Day in Date Column Advanced Filter BCM (Business Contact Manager) 1
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
S Body text of Email from invite date/time Outlook VBA and Custom Forms 7
V 10 Years calenders -single date together Exchange Server Administration 8
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
X If you change expiration date of repeated task it dupplicates Using Outlook 1
D Archive by receive date not working Using Outlook 2
V Making a Date field mandatory in outlook form Outlook VBA and Custom Forms 2
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
L Ctrl Alt d date stamp use Using Outlook 1
A Create date folder and move messages daily Outlook VBA and Custom Forms 1
witzker Outlook 2010 Insert Date & Time at the button of an OL contactform in red Using Outlook 2
O Tasks - Is there a postponed date column? Using Outlook 7
J Command Button to stamp a date and time in a textbox in Outlook 2016 Outlook VBA and Custom Forms 3
K Outlook Archive to PST Files by Date Range VBA Script? 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
F Finding Meetings/Tasks in a date range Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
V Changing default date for task follow-up buttons Using Outlook 2
J Old unread emails on current date (MDaemon Server) Using Outlook 1
D Outlook macro with today's date in subject and paste clipboard in body Outlook VBA and Custom Forms 1
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
B Search by date macro Outlook VBA and Custom Forms 0
S set a flag task date as the next weekday Outlook VBA and Custom Forms 4
K Daily task list > show tasks on the exact due date and not on the "current date" Using Outlook 1
S Outlook User defined date field (UDF) not syncing Using Outlook 2
I Email Replied for first time Date/Time Outlook VBA and Custom Forms 2
E Outlook 2010 disable date auto-complete Using Outlook 2
Diane Poremsky Display the Created Date field of any Outlook item New Slipstick.com Articles 0
L set task reminder date to same as start date (without affecting due date) Using Outlook 0
Patrick van Berkel Best way to share (and keep up-to-date) Macro's in Outlook 2010 Outlook VBA and Custom Forms 6
GregS "Your <mail provider> settings are out of date" Using Outlook 0
C Recurring Task End Date Varies Using Outlook 3
P Date Picker in email Using Outlook 4
S stop calendar date reverting to today Using Outlook 7

Similar threads

Top