I cannot remember the combo to Auto enter the long date within the Subject line via Outlook VBA
Sorry for cluttering if this has been posted before, I couldn't find a thread with this.
The attached sheet has the basics, only needing the population of the Long Date
Please Login or Register to view this content.
Last edited by 6StringJazzer; 09-14-2021 at 03:08 PM. Reason: replaced attachment with actual code
Please don't attach a file with text to show your code, just put the code in your post using CODE tags. I have streamlined your post.
"long date" is not specific. You can modify the format above as needed.Please Login or Register to view this content.
In VBA, you can use Date, Time and Now to get those system values.
?Date
14/09/2021
?Time
20:09:46
?Now
14/09/2021 20:09:56
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You are the best!
6StringJazzer Thank you very much for that!
One question, did I delete, move, or miss the portion to add my signature to the email?
Thank you TMS!
I read thru regarding the signature (Looking at Example 2) / & your how to page, however, how do I marry your code with the one from 6stringjazzer?
To only pull the signature and insert it without automatically sending?
What would I pull and add to where?
Use .Display rather than .Send
🤦*♂️Duh
Thank you very much TMS!!!
Thank you very Much 6StringJazzer!!!
You're welcome and thanks for the rep!
Ditto!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks