Solved

Forwarding multiple emails in Outlook 2007 within body of text

Posted on 2010-11-10
7
538 Views
Last Modified: 2012-05-10
Outlook 2007 - Is there a way to select and forward multiple emails within a single email without them going as multiple attachments?   Would like the full text of all the forwarded emails to be contained inside the main email.  We have users that cannot receive attachments.
0
Comment
Question by:DBI-DT
  • 3
  • 3
7 Comments
 
LVL 10

Expert Comment

by:Tyler Laczko
Comment Utility
You cannot do this without coping / pasting the text of the emails.
0
 
LVL 76

Expert Comment

by:David Lee
Comment Utility
Hi, DBI-DT.

I can do it with a simple macro.  If that's an option, then I can post the code and instructions.
0
 

Author Comment

by:DBI-DT
Comment Utility
I'll take it!
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 76

Expert Comment

by:David Lee
Comment Utility
Which email will be the "main" email?
0
 

Author Comment

by:DBI-DT
Comment Utility
The user will select several emails and then click Forward, creating the "Main" email.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 250 total points
Comment Utility
Got it.  Here's the code.  Follow these instructions to add it to Outlook.

1.  Start Outlook
2.  Click Tools > Macro > Visual Basic Editor
3.  If not already expanded, expand Microsoft Office Outlook Objects
4.  If not already expanded, expand Modules
5.  Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting Insert > Module.
6.  Go to this Microsoft KB article (http://support.microsoft.com/kb/274326)
7.  Copy the code from step #4 and paste it into the right-hand pane of Outlook's VB editor window
8.  Copy the code from the Code Snippet box and paste it into the right-hand pane of Outlook's VB Editor window below the other code
9.  Click the diskette icon on the toolbar to save the changes
10. Close the VB Editor

To use this

1.  Select one or more messages
2.  Run the FwdMultiple macro

The macro creates a new message then copies and pastes the contents of the other messages into it.

Sub FwdMultiple()
    Dim olkFwd As Outlook.MailItem, olkMsg As Outlook.MailItem, olkDoc As Object, strTempHTML As String
    Set olkFwd = Application.CreateItem(olMailItem)
    With olkFwd
        Set olkDoc = olkFwd.GetInspector.WordEditor
        .Display
        .Subject = "FW: Multi-item Forward"
        For Each olkMsg In Application.ActiveExplorer.Selection
            strTempHTML = "<br><hr><br><b>From:</b> " & olkMsg.SenderName & "<br>" _
                & "<b>Sent:</b> " & olkMsg.SentOn & "<br>" _
                & "<b>To:</b> " & olkMsg.To & "<br>" _
                & "<b>Subject:</b> " & olkMsg.Subject & "<br><br>" & olkMsg.HTMLBody
            PutHTMLClipboard strTempHTML
            olkDoc.Windows(1).Selection.EndKey wdStory
            olkDoc.Windows(1).Selection.Paste
        Next
    End With
    Set olkFwd = Nothing
    Set olkMsg = Nothing
    Set olkDoc = Nothing
End Sub

Open in new window

0
 

Author Closing Comment

by:DBI-DT
Comment Utility
Needed a simpler solution.   Found work-around.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now