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

Thanks in advance!

Hi SAI80,

Try the attached file that contains the following code. I added items to the 'Comments' column for additional visibility. There are several items at the top of Ordinary Code module ModOutlookFindEmail in red that can be changed if you change your design requirements.


Please let me know if you have any questions or need any additional assistance.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

July 21, 2020 - Attachment deleted by poster due to runtime error when Subject contains a colon ':' character. See the file associated with post #7 in this thread for a corrected attachment.