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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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)
 

Aussie

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
Diane ... thanks for the starter code ... I'll see what I can do ...
 

KoolPal

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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.
Thread starter Similar threads Forum Replies Date
B Looking for Outlook 2013 update for Send Drafts Macro Using Outlook 4
L Looking for help - want to try an alternative to Outlook? Outlook Wishlist 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
U Looking for a person/company that we can PAY for Outlook 2003 tech service Using Outlook 0
T I am looking for a Microsoft Outlook Email Stationery download? Using Outlook 5
D Microsoft Outlook not operating and is clouded looking Using Outlook 1
B Outlook 2007 at odd times shuts down then states it is looking for problem then starts up again Using Outlook 1
S Outlook 2003 (when looking at emails shows my name and not who sent the emails) Using Outlook 2
S Outlook wont load - looking for microsoft exchange Using Outlook 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
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
P Looking for Christmas Theme (thmx file) Using Outlook 5
W "Looking for credential tiles..." when connecting to Exchange 2007 Using Outlook 4
M I am looking for support options for taskmanager in 2010 Using Outlook 1
P Looking for suggestions regarding a multi-site high availability/disaster resistant design Exchange Server Administration 1
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
P outlook 2008 search box criteria couldn't be saved Using Outlook 2
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
C Outlook with Office365 - search across account, by date rate, in multiple folders - how? Using Outlook 1
D Outlook 2010 Outlook in Windows 10 keeps asking for user name and password repeatedly Using Outlook 14
S Outlook mail adressing stops after first match in GAL Using Outlook 0
A Apply Selected Emails to outlook rules and Run Rules Using Outlook 5
T Changing Sent Items location in Outlook 2019 Using Outlook 0
J How do I disable advertising in Outlook 2019? Using Outlook 10
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
L Unable to Sync Web/Android MS To Do with Windows Outlook Tasks Using Outlook 3
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
B Outlook Calendar not coming down from cloud Using Outlook 2
Terry Sullivan Sender's Name Doesn't Appear in the From Field on Outlook 365/IMAP Using Outlook 2
GregS Outlook 2016 Can I disable the Outlook Outbox? Using Outlook 2
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
Similar threads


















































Top