Results 1 to 3 of 3

Need VBA Code to Copy & Paste Only Subject & Received Time of an E-Mail into Excel!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Smile Need VBA Code to Copy & Paste Only Subject & Received Time of an E-Mail into Excel!

    Dear Friends,

    Please open this attachment

    E-Mail Lists Work Sheet:-

    In this, I have defined From E-Mail ID & To E-Mail ID which is default (Will not change very often).

    What I would like to accomplish here is,

    The moment there is an E-Mail alert From: this particular E- Mail ID to mentioned To: E-Mail ID

    I want that Received Time & Subject of the E-Mail to get updated in Raw Data Work Sheet Column B & C Accordingly (one below one).

    Note: This Excel Workbook will be saved in a centralized Network path. Link looks something as below….

    \\CompanyName\DivisionName\Functions\DepartmentName\ExcelFile

    Could you please suggest, How to achieve this?

    Thanks & Regards,
    Rajeshkumar R

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run *.bat once the outlook mail received with Subject line "welcome" on daily by user
    By yogananda.muthaiah in forum Outlook Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2021, 10:23 AM
  2. COPY outlook mails subject, received date, sender details in excel
    By Ratnakar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 10:14 AM
  3. Mail subject number to excel macro
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 04:48 PM
  4. Copy from excel and paste in Outlook New Mail
    By wish2excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2011, 08:38 AM
  5. Copy E-mail subject line to Excel
    By tapapad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2009, 11:04 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