+ Reply to Thread
Results 1 to 4 of 4

Filing Sent Items

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Filing Sent Items

    Hello,

    We currently have a macro on our Outlook here at work that prompts the user to select a folder to save a sent item in a selected folder each time they click send. I didn't write this code and i have to confess that I know nothing about VBA in Outlook (I'm more of an Excel man).

    I have been asked to see if I can change the macro so that as well as saving the sent item in the selected folder, a copy is also placed in the sent items folder so that people can easily view a list of all items sent.

    Can anyone please tell me what needs to be added to this code in order to achieve this:

    Please Login or Register  to view this content.
    Thanks
    Steven

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

    Re: Filing Sent Items

    See https://msdn.microsoft.com/en-us/lib.../ff868420.aspx

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

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Filing Sent Items

    Thanks Skatonni. That works but it causes the macro loop because the macro is triggered by an item appearing in the sent items folder.

  4. #4
    Registered User
    Join Date
    12-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Filing Sent Items

    I've managed to solve this with this:

    Please Login or Register  to view this content.
    Thanks to this helpful chap here:

    http://www.vbaexpress.com/forum/show...ing-Sent-Items

+ 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. Filing Macro - Simple ... It would seem
    By WillJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2014, 08:15 AM
  2. Auto-filing a Series
    By forgameslive in forum Excel General
    Replies: 4
    Last Post: 08-04-2013, 05:59 PM
  3. Filing data into drip slots
    By Justinmih in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-04-2008, 07:04 PM
  4. Filing system
    By poppedinsouled in forum Excel General
    Replies: 4
    Last Post: 04-13-2007, 04:47 PM
  5. Removing filing extension from header
    By fixcpa in forum Excel General
    Replies: 4
    Last Post: 06-01-2005, 07:05 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