Outook 2007: Dear (First Name_

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
One other question today.

Is there a way to create an email template or macro that automatically starts the email to the contact I clicek with the words:

Dear (first name):

And I will have other words as part of the template, but want the beginning to be to the first name from the contact I click or open...

Any way to do it?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can do it one of two ways - both using VBA. See Merge to email using only Outlook - Slipstick Systems - the birthday greeting page sample is all vba, or you can use VBA and bookmarks. Bookmarks work good if you are doing a form letter and want to insert a field in the middle of test. .
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks very much. I reviewd the link you gave me and per the earlier help, you sent the macro as a notepad which was better for me. Do you have it as a notepad with only the area of Dear (first name) and no other words in the text area, which I will create in the template.

Thanks again very much, as all your support has been perfect!
 

Forum Admin

Senior Member
You just need to add this line to the other macro

objMsg.Body = "Dear " & ocontact.FullName & vbcrlf & vbcrlf & objMsg.Body

If the formatting doesn't look right and you are using HTML message format use this instead:

objMsg.HTMLBody = "Dear " & ocontact.FullName & vbcrlf & vbcrlf & objMsg.HTMLBody
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Once again, works great!! Follow-up is that I want to juse the first name the full name, and the font of the Dear (name) does not match the font of the email template.....

Any way to adjust each of those?

Thanks so much!
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Just changed the words in the macro from FullName to FirstName and that did it.

So just need to know how to do the font also if I want a , or a : after the name, how do I add that to the macro as I tried to put the , after the "FullName" and that did not work
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
No problem....I am learning from you!!

So, just need to know how to do the font for the words Dear (name) I want a coma , or a colon : after the name, is there a way to do those both?
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Just figured how to add the colon: objMsg.HTMLBody = "Dear " & oContact.FirstName & ":" & vbCrLf & vbCrLf & objMsg.HTMLBody

So now just need to know how to make the font of the words "Dear (name)" be what the font of words are in the email.
 

Forum Admin

Senior Member
It should be the same font. When you look at the Font in a new message, does it say Fontname (Body) or just Fontname ?

body.png
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Fontname....the default font is Calibri 11, and the "Dear (firstname)" showed up as Times New Romen 12
 

KoolPal

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Just figured how to add the colon: objMsg.HTMLBody = "Dear " & oContact.FirstName & ":" & vbCrLf & vbCrLf & objMsg.HTMLBody

So now just need to know how to make the font of the words "Dear (name)" be what the font of words are in the email.
Hi,

I am looking for just this kind of a code when I start my reply to any email.

Can you please share the vba code for this?
 

Nikh

New Member
Outlook version
Outlook 2007
Email Account
POP3
Hi,....Can you send me macro code that automatically capture first name from .TO field while replying mails.

ie. Dear (First name)
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
A cannot access OWA or connect to exchange 2007 via outook. Using Outlook 5
S Saving Excel document to a network drive within Outook 2007 Using Outlook 1
V Need help on configuring Outook 2003 Rules and Alerts... Using Outlook 2
R Synchronizing email in Outook beween 2 computers Using Outlook 2
S Outook Transmission Error 0x80040201 Using Outlook 1
S Outook 2002 SP3 - cant import a contact list Using Outlook 1
S Lose Calendar When Inside Outook On Windows Server 2003 Using Outlook 2
T MS Outook 2003/MSI problem Using Outlook 3
S Outook 2003 - Archive feature not available Using Outlook 3
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
B Outllok 2007 License Expired issue Using Outlook 0
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
Steven 2007 New PC vs Old PC - Micro Font on Inbound Emails :( Using Outlook 4
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
P Oulook addin unloaded in office 2007 Outlook VBA and Custom Forms 2
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
norbertlars Exchange 2007 - quota not shown in clients Exchange Server Administration 2
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
Similar threads


















































Top