Looking for Outlook macro to Copy Recipient Names into Email Body

Status
Not open for further replies.

Aussie

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
All,

Nice forum ... I am somewhat a newbie ... and I like writing VBA :)

I searched but could not find any VBA to allow me to Copy an email's Recipient Names into the introductory line of the Email Body.

So, for example, when I have added email addresses to the "To:" line:
To: lsywalker@outlook.com, dmaul@outlook.com

I would like to run a macro that adds a line like this to the first line in the body of the email. That is, extract the first names for each contact from the contact list and concatenate them:
Dear Luke, Darth,

And then complete the rest of the body text manually?

Can this be done? Can someone please point me in the right direction (e.g., sample code snippet)

Thanks in advance.
 
If you are doing a mail merge or are picking up the address from a contact you can insert the contact name. I have samples that do this. If you are just replying, you could use the person's display name (not always the best idea because it might be in last, first order).

Looking up a contact is doable but I'm not sure if i have any code samples that show how.

you'd use something like
Set oContact = colItems.Find("[FullName] = '" & sSenderName & "'")
If Not (oContact Is Nothing) Then
' use something else for the introduction
else
' get the name from the found contact
ocontact.fullname
end if

(the Find snippet is from http://www.slipstick.com/developer/create-contacts-from-messages/ - which checks for contacts before creating one for the sender of a message)
 
Diane ... thanks for the starter code ... I'll see what I can do ...
 
I've been hunting for this for a long time with no luck! Perhaps now I'll get the solution!!
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Looking for Outlook 2013 update for Send Drafts Macro Using Outlook 4
C Looking for feedback on new Outlook Add-in Using Outlook 0
D Looking to move away from exchange to outlook.com Using Outlook 4
O looking to bring in all my folders from Outlook Express (XP) to Outlook 2013 Using Outlook 3
R Outlook Template: Looking to distribute a VBA Outlook template to other people Using Outlook 1
Q Looking for Outlook 2010 Close Event Id Exchange Server Administration 1
S Looking for client-side method (Outlook 2007/Exchange 2007) for users to delete Outlook VBA and Custom Forms 2
P Outlook looking for Copy of Outlook.pst Outlook VBA and Custom Forms 1
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
G Looking for help with our Organization Forms Library Outlook VBA and Custom Forms 1
peacepanda How to save attachment looking at the attachment name Outlook VBA and Custom Forms 1
M Looking for options and best practices for an Edge Server (Exchange or not) Exchange Server Administration 0
M Looking for trainer in Business Contact Manager BCM (Business Contact Manager) 0
B Looking for an add-in or a way to send automatic replies based off a list Using Outlook 2
J Looking for a solution (maybe an add-in) to easily track email conversations Using Outlook 3
I Looking for a productivity add-in similar to "Nostalgy" for Thunderbird Using Outlook 5
C Looking for way to tie a Business Contact to more than one Account BCM (Business Contact Manager) 5
J OL2003 Macro disables itself - looking for way to automate 'enable' Using Outlook 2
R Looking for my BCM backup files BCM (Business Contact Manager) 1
B Looking for email address under ItemSend event Outlook VBA and Custom Forms 6
S Looking for a Utility for Editting An Exported Rules (.rwz) File Using Outlook 6
U looking for feedback on installation process and on eMarking Assis Outlook VBA and Custom Forms 1
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 1
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0
kburrows "New" Outlook Desktop App Mailbox Size Using Outlook 3
N Best way to sync calendar and contacts between Outlook 365 and Outlook on iPhone Using Outlook 4
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
Y The New Outlook - Q's & Thoughts Using Outlook 16
M Start Outlook 365 at unified inbox Using Outlook 2
B Requesting VBA code to make Outlook prompt for confirmation when deleting a task? Outlook VBA and Custom Forms 4
T In-line reply style in Outlook II Outlook VBA and Custom Forms 1
G Outlook Contact Item.Restrict where FullName is NULL Outlook VBA and Custom Forms 3
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
W Outlook 2021 Hanging on "Sending Emails" Using Outlook 3
T Outlook Desk Top 2021 Overdoing Security Using Outlook 7
O Any 3rd party tool that sync (mirror) from Outlook Contacts to Google Contacts? Using Outlook 4
D Outlook 365 Outlook Message "Cannot be sent because the message has changed" Using Outlook 0
J Hotmail drafts started on desktop disappear, but show in web version of Outlook Using Outlook 4
Z Hotmail account deleted from outlook and issue with account not exist Using Outlook 0
J 'Name on the security certificate is invalid or...' - Outlook on desktop talking to hotmail.com account Using Outlook.com accounts in Outlook 5
J Outlook, Word, Access crash unless run in Admin mode - time dependent it seems Using Outlook 10
T Why do Outlook Desktop 2021 tasks from my wife's email show up in my task pane? Using Outlook 2
B Delete Read Receipts in Your Outlook Outlook VBA and Custom Forms 0
M Outlook changes the "Modified" field when moving/copying a Contact. Using Outlook 0
macdotcom Outlook 365 Outlook folder export to PST archival tool - close, but need a nudge Outlook VBA and Custom Forms 2
M Outlook 2016 still feature updating Using Outlook 0
e_a_g_l_e_p_i Question about Outlook 2021 and Gmail Using Outlook 8
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 4

Similar threads

Back
Top