+ Reply to Thread
Results 1 to 2 of 2

Macro for moving mails to folders according to specific criteria

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    prague
    MS-Off Ver
    2007
    Posts
    1

    Question Macro for moving mails to folders according to specific criteria

    Hello,
    Me and my colleagues are facing quite an unusual problem. We daily receive several messages with specific format. We need to sort this messages according to the body text, to be precise according to text in the 2nd and 4th line.

    Here is an example:
    SCR
    S14
    02JUL
    PRG
    K QS100P 02JUL02JUL 0030000 00073H 0740BTS P

    This is a message from our partner and we need to move it automatically from INBOX folder (or any other folder) to the folder S14 (line 2) and subfolder PRG (line 4)


    Currently we have a file tree and we sort these messages manually, which is obviously a pain.

    I found several tips how to create a macro which moves messages to personal folders but I can't implement the If condition (if there is specific text on line 2 move it to specific folder).

    Could you please help me to create such macro?

    Thanks a lot in advance!

  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Macro for moving mails to folders according to specific criteria

    Quote Originally Posted by lowflyer View Post
    Hello,

    Here is an example:
    SCR
    S14
    02JUL
    PRG
    K QS100P 02JUL02JUL 0030000 00073H 0740BTS P

    I found several tips how to create a macro which moves messages to personal folders but I can't implement the If condition (if there is specific text on line 2 move it to specific folder).
    Try using split to determine lines 2 and 4.

    Please Login or Register  to view this content.

+ 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. Macro to list a specific type of file searching in folders and subfolders
    By vamu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2014, 09:31 AM
  2. VBA Macro to loop through folders and select files with certain criteria
    By sbl56vikes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2014, 06:05 PM
  3. Saving mails in respective folders
    By ramserp in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2010, 04:56 AM
  4. [SOLVED] Moving workbooks between folders
    By Ozzie in forum Excel General
    Replies: 3
    Last Post: 01-25-2006, 05:30 AM
  5. Moving files between folders using VBA in Excel
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2005, 10:05 AM

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