+ Reply to Thread
Results 1 to 4 of 4

Extract Month and year in VBA Code to email in body of email

  1. 07-10-2019, 09:09 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Extract Month and year in VBA Code to email in body of email

    I have the following snippet of Code to send to the body of an email




    Please Login or Register  to view this content.

    It would be appreciated if someone could assist me
    Reply With QuoteRegister To Reply
  2. 07-10-2019, 09:14 AM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Extract Month and year in VBA Code to email in body of email

    Hi Howardc1001,

    Your code has a bit of a syntax issue...

    Please Login or Register  to view this content.
    should actually be
    Please Login or Register  to view this content.
    I would use

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  3. 07-10-2019, 09:26 AM #3
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Re: Extract Month and year in VBA Code to email in body of email

    Thanks for the help, Arkadi

    Your suggested code works perfectly
    Reply With QuoteRegister To Reply
  4. 07-10-2019, 02:30 PM #4
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Extract Month and year in VBA Code to email in body of email

    Glad to hear it Thanks for the feedback, the rep, and marking the thread as solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Email Body Info using Excel VBA
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-28-2018, 06:58 PM
  2. Code to send email with table on the email body via gmail
    By ivhee00 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2017, 12:24 AM
  3. RE: Extract body from email
    By djtprior in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2015, 08:36 AM
  4. [SOLVED] export email body to excel workbook with year/month date in file extension
    By john.tm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2014, 09:24 AM
  5. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  6. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  7. Excel code to email whats in the spreadsheet in the body of email
    By Kain93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 09:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1