+ Reply to Thread
Results 1 to 3 of 3

Edit all emails in folder with the same note and then move to another folder

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Edit all emails in folder with the same note and then move to another folder

    Hi Everyone,

    I hope you can help me. n00bie here. :p

    I action emails during the day and I move the actioned emails to a separate folder that only I use called "Actioned today". At the end of the day, I can go to that one folder and quickly count the amount of emails I have actioned.

    At the moment, I open up about 10 emails at a time and click on a macro button to make the macro:

    1. edit the email by adding a note to the top of the email
    2. moving it to a shared "closed" box with a million other emails
    3. email is subsequently closed.


    I just keep on clicking on the macro button until all the emails are closed and open another 10 emails until all the emails in the "Actioned today" email folder is gone.

    It used to be okay, but because of the influx of emails, I have to do this for 50+ emails a day and my computer gets slow and laggy from trying to open and then process the open emails.


    I would like a macro which could automatically go into each email in a particular email folder and edit the email by adding a note to the top of the email, then moving it to the shared "closed" box.

    Basically I'm trying to eliminate the need of manually opening each email and clicking on the macro button 100times.


    I did write something up but it didn't work and it looked so mediocre I just Ctrl+A and Deleted it out of frustration!


    I hope you can help me


    My current code: (I know it is a bit messy but it works!)



    Please Login or Register  to view this content.
    Last edited by missnk; 08-07-2014 at 02:57 AM.

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

    Re: Edit all emails in folder with the same note and then move to another folder

    Make a selection of mails. No need to open any.

    Please Login or Register  to view this content.
    To mark "Solved" go to Thread Tools.

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Edit all emails in folder with the same note and then move to another folder

    Thank you!! That's worked!! :D

    I had to change:

    If objItem.BodyFormat = olFormatPlain Then

    To:

    If objItem.BodyFormat <> olFormatPlain Then


    because it wasn't picking up the plain text emails in the folder for some reason.

    Thanks again!! A++

+ 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. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  2. [SOLVED] copy emails from outlook into a folder
    By plans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2014, 02:26 PM
  3. Replies: 6
    Last Post: 08-11-2006, 03:41 PM
  4. Move Files from Folder to Folder
    By THE_RAMONES in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 04:25 PM
  5. Import emails from outlook folder as TXT
    By Mslady in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2005, 08:07 PM

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