Salutation Column in Excel Spreadsheet

[Pam]

I'm using an Excel spreadsheet to create a "Dear Dr."
form letter. I need to add a column for the salutation,
but since there are 4000 lines, I don't want to retype
all of the names adding Dr. before the last name. Is
there a code that I could insert that would automatically
create a salutation column that had Dr. and then the last
names?
Thanks, Pam

 

[Guest]

Pam
It sounds like you might be better of using Tools>Mail_Merge in Word. You can use your Excel file of the names as the data source

Good Luck
Mark Graesse
(e-mail address removed)

----- Pam wrote: ----

I'm using an Excel spreadsheet to create a "Dear Dr."
form letter. I need to add a column for the salutation,
but since there are 4000 lines, I don't want to retype
all of the names adding Dr. before the last name. Is
there a code that I could insert that would automatically
create a salutation column that had Dr. and then the last
names
Thanks, Pa