How to insert all recipient names to email body in Outlook?
Sometimes, you may need to insert the names of all recipients into the message body when composing an email in Outlook. Of course, you can copy and paste the names into the body one by one. But, it is very tedious if there are dozens of recipient names need to be pasted. This article, I will talk about an easy way to solve this job in Outlook.
The following VBA code can help you to insert all recipient names from To field into the message body, please do as this:
1. Launch the Outlook, and then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Insert recipient names into message body:
Sub InsertRecipientNamesToBody() Dim xMailItem As Outlook.MailItem Dim xRecipient As Outlook.Recipient Dim xRecipAddress, xRecipNames, xRecipName, xFilterAddr As String Dim xItems As Outlook.Items Dim i As Integer Dim xFoundContact As Outlook.ContactItem Dim xDoc As Word.Document On Error Resume Next Set xMailItem = Outlook.ActiveInspector.CurrentItem xMailItem.Recipients.ResolveAll For Each xRecipient In xMailItem.Recipients xRecipAddress = xRecipient.Address Set xItems = Application.Session.GetDefaultFolder(olFolderContacts).Items For i = 1 To 3 xFilterAddr = "[Email" & i & "Address] = " & xRecipAddress Set xFoundContact = xItems.Find(xFilterAddr) If Not (xFoundContact Is Nothing) Then xRecipNames = xRecipNames & xFoundContact.FullName & Chr(10) Exit For End If Next If (xFoundContact Is Nothing) Then xRecipName = Split(xRecipAddress, "@")(0) xRecipNames = xRecipNames & xRecipName & Chr(10) End If Next Set xDoc = xMailItem.GetInspector.WordEditor xDoc.Content.InsertAfter xRecipNames Set xMailItem = Nothing Set xRecipient = Nothing Set xItems = Nothing Set xFoundContact = Nothing End Sub
3. And then still in the Microsoft Visual Basic for Applications window, click Tools > References to go to the References-Project1 dialog box, and check Microsoft Word Object Library option from the Available References list box, see screenshot:
4. Then click OK to close the dialog, now, you should add this code to the Quick Access Toolbar.
5. Create a new message by clicking New Email, in the Message window, click Customize Quick Access Toolbar icon, and select More Commands, see screenshot:
6. In the Outlook Options dialog box:
(1.) Select Macros from the Choose commands from drop down list;
(2.) And then choose the VBA code name which you have inserted just now;
(3.) Click Add button to add the code into the Customize Quick Access Toolbar list box.
7. And then a macro icon is displayed into the Quick Access Toolbar as following screenshot shown:
8. Now, when you click the macro icon, the recipient names from the To field will be inserted into the message body as following screenshot shown:
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
- BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
- Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
- Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
- Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.