+ Reply to Thread
Results 1 to 3 of 3

copy emails from outlook into a folder

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    copy emails from outlook into a folder

    Hello,
    I am sending e-mails through an Excel Macro.
    I want the sent e-mail to be taken from Outlook “Sent Items” and copy it to a certain folder on my computer.
    Could anyone advise?
    Thanks

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: copy emails from outlook into a folder

    Do you need the actual emails? Or just the details in text format from the Subject, To, Body? If so, you can easily create text files from the code you are using to send the emails.

  3. #3
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: copy emails from outlook into a folder

    I figured it out.
    I wrote this just before the ".send":
    itmMail.SaveAs (Filelocation & "\EmailToSave.msg")
    Where "Filelocation" is where my current open Excel File resides.
    It works smoothly;
    Thank you for the response!

+ 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. [SOLVED] Select folder and date range to get emails from Outlook
    By 2sqrd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2013, 09:51 AM
  2. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  3. [SOLVED] Need Excell Macro to send out all the emails from Outlook Drafts folder
    By anto_01 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-16-2012, 11:29 PM
  4. Send outlook emails with message in cells to individual emails associated with them
    By abinayan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 06:11 AM
  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