+ Reply to Thread
Results 1 to 10 of 10

Email Creation from VBA with Custom Subject Line

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    NY, NY
    MS-Off Ver
    365
    Posts
    6

    Email Creation from VBA with Custom Subject Line

    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

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Email Creation from VBA with Custom Subject Line

    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.

    Please Login or Register  to view this content.
    "long date" is not specific. You can modify the format above as needed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,478

    Re: Email Creation from VBA with Custom Subject Line

    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 - Excel Aid

    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


  4. #4
    Registered User
    Join Date
    06-17-2020
    Location
    NY, NY
    MS-Off Ver
    365
    Posts
    6

    Re: Email Creation from VBA with Custom Subject Line

    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?

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,478

    Re: Email Creation from VBA with Custom Subject Line


  6. #6
    Registered User
    Join Date
    06-17-2020
    Location
    NY, NY
    MS-Off Ver
    365
    Posts
    6

    Re: Email Creation from VBA with Custom Subject Line

    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?

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,478

    Re: Email Creation from VBA with Custom Subject Line

    Use .Display rather than .Send

  8. #8
    Registered User
    Join Date
    06-17-2020
    Location
    NY, NY
    MS-Off Ver
    365
    Posts
    6

    Re: Email Creation from VBA with Custom Subject Line

    🤦*♂️Duh
    Thank you very much TMS!!!
    Thank you very Much 6StringJazzer!!!

  9. #9
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Email Creation from VBA with Custom Subject Line

    You're welcome and thanks for the rep!

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,478

    Re: Email Creation from VBA with Custom Subject Line

    Ditto!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Email set of cells with identified email list and subject line with outlook
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2020, 01:18 PM
  2. [SOLVED] Custom subject line with vb
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2013, 01:54 PM
  3. Replies: 0
    Last Post: 08-16-2011, 02:40 PM
  4. Tab Name in Email Subject Line
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-20-2010, 02:37 PM
  5. Value of a cell for email subject line
    By Kevin K. Chlipa in forum Excel General
    Replies: 4
    Last Post: 11-28-2008, 06:45 PM
  6. Auto email from excel with custom subject
    By Vikram in forum Excel General
    Replies: 12
    Last Post: 07-27-2006, 10:45 PM
  7. Changing subject line in email
    By tanyhart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2006, 11:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1