Results 1 to 7 of 7

Email/Attachments Copy and Register through Excel Macro

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    22

    Email/Attachments Copy and Register through Excel Macro

    Hi,

    I would like to automatize email register, I'd appreciate if someone can Help me.

    I would mark as Red Cathegory some emails in Outlook 2013.
    Then from a file in ‘D:\user\mail\in’ (see attached) I want to actívate a macro and:

    1. Save a copy of those emails in ‘D:\user\mail\in\emails’ with name: Received - Subject (yymmdd_hhmm - Subject.msg)

    2. If email has attachments, sabe attachments in ‘D:\user\mail\in\attachments\aammdd_hhmm_#’ (the # is in case i got multiple emails from same minute)(I am aware this way I am duplicating these files which are in email copy, and on their own (plus in Outlook)).

    3. in Excel File, it completes list with the emails and attachments that have been copied, and creating hypervincles to them.

    4. Once this is done, it changes email cathegory to Green.

    All of these files will be in a server, so multiple users will need to be able to use this file, not sure if this changes anything.

    Thanks a lot for your Help!!!
    I
    Attached Files Attached Files
    Last edited by SAI80; 07-07-2020 at 06:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro for Email attachments from excel list fails when first line is " "
    By jgriffi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2019, 03:23 PM
  2. copy data from outlook email attachments to a local file
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 10:24 AM
  3. Copy Outlook email attachments to Local drive(specified Path)
    By Nanimadhu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2014, 08:26 AM
  4. Replies: 0
    Last Post: 02-21-2013, 04:46 AM
  5. [SOLVED] Excel Macro to download email attachments from MS Outlook.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2010, 02:10 PM
  6. adding multiple attachments to a macro in excel for a email using outlook
    By ccbltdneedhelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 11:03 AM
  7. email several attachments (change to ron's macro?)
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2005, 11:05 PM

Tags for this Thread

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