Results 1 to 10 of 10

Email Creation from VBA with Custom Subject Line

Threaded View

  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

    Sub SendMail()
    
       Dim MyEmail As MailItem
       Set MyEmail = Application.CreateItem(olMailItem)
       
       With MyEmail
          .To = "[email protected]"
          .Importance = olImportanceNormal
          .Subject = "Message - " ' ----------------- > Wishing to Auto Add todays Long Date
          .Body = "@ "
          .BodyFormat = olFormatHTML
          .Display
       End With
    
    End Sub
    Last edited by 6StringJazzer; 09-14-2021 at 03:08 PM. Reason: replaced attachment with actual code

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