+ Reply to Thread
Results 1 to 6 of 6

extracting Email from current date

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    HONG KONG
    MS-Off Ver
    2010
    Posts
    8

    Unhappy extracting Email from current date

    Hi everyone,

    I am using one vba to extract the email, can I add some code inside to extracting only the email of the current date?
    Please Login or Register  to view this content.
    Thanks every expert!
    Last edited by a166769344; 11-05-2019 at 10:22 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: extracting Email from current date

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

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

    Re: extracting Email from current date

    Untested, but try:

    Please Login or Register  to view this content.
    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


  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: extracting Email from current date

    This works fine for me.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Registered User
    Join Date
    10-23-2019
    Location
    HONG KONG
    MS-Off Ver
    2010
    Posts
    8

    Re: extracting Email from current date

    Hi everyone,

    It runs perfectly.

    Many many thanks for you guys!!

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: extracting Email from current date

    You're welcome and thanks for feedback.

+ 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. How to write macro to send email when date is matching with current date
    By gunanidhi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2016, 02:16 AM
  2. Extracting Email Received Date and Time and Subject line from Inbox (WebMail)
    By Naveed Raza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2015, 01:19 AM
  3. Replies: 0
    Last Post: 06-28-2014, 09:31 AM
  4. [SOLVED] Enter current date and time in subject of macro email
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2013, 11:15 AM
  5. Modity on current code to prompt due date & auto email
    By cyee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2013, 04:00 AM
  6. Sending email using excel with current time/date
    By undergraduate in forum Excel General
    Replies: 1
    Last Post: 03-24-2010, 02:11 AM
  7. Extracting data from the current date
    By Cali00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2005, 01:06 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