+ Reply to Thread
Results 1 to 4 of 4

forwarding an email

  1. #1
    Forum Contributor
    Join Date
    12-18-2015
    Location
    scotland
    MS-Off Ver
    MS office 365 business
    Posts
    187

    Arrow forwarding an email

    hi

    can someone help me here, is there a way to automatically forward an email to a particular folder after it has been read, not sure if this or something similar can be done

    thanks in advance
    toddp2

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: forwarding an email

    Untested here :

    https://stackoverflow.com/questions/...a-local-folder

  3. #3
    Forum Contributor
    Join Date
    12-18-2015
    Location
    scotland
    MS-Off Ver
    MS office 365 business
    Posts
    187

    Re: forwarding an email

    hi got the sub just dont know how to apply it to my folder

    Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    Call SaveACopy(Item)
    End Sub


    Sub SaveACopy(Item As Object)
    Const olMsg As Long = 3

    Dim m As MailItem
    Dim savePath As String

    If TypeName(Item) <> "MailItem" Then Exit Sub

    Set m = Item

    savePath = "c:\users\peter_todd\desktopfolder\" '## Modify as needed
    savePath = savePath & m.Subject & Format(Now(), "2021-06-18-08:30")
    savePath = savePath & ".msg"


    m.SaveAs savePath, olMsg

    End Sub

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: forwarding an email

    Outlook has a VBE editor just like Excel. You would place the macro into a regular module in the Outlook VBE and then
    run the macro like you would in Excel.

    Admittedly I am not very familiar with Outlook programming as I have never had the need.

+ 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. Forwarding attachment
    By toddp2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 01-17-2020, 04:44 AM
  2. Formatting an email before forwarding macro
    By taylorsm in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2017, 12:01 PM
  3. Removing hyperlinks from email via VBA and then forwarding emails
    By jfucochan in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 05:52 AM
  4. Forwarding excel files to an email address
    By Khanzaki in forum Excel General
    Replies: 6
    Last Post: 12-28-2012, 06:19 AM
  5. Renaming attachment when forwarding
    By shekharsom in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2012, 02:32 AM
  6. Mail forwarding
    By me_king in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2012, 10:20 PM
  7. Automatic Email forwarding
    By champs in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-26-2009, 07:21 AM

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