View Single Post
 
Old 11-09-2013, 10:57 PM
Charles Kenyon Charles Kenyon is offline Windows 7 64bit Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Vic01 View Post
Thanks so much for your reply.
I have, in fact, an excel sheet with hundreds of doctor's names and addresses.
I'm not keen on having to re-type this information in building blocks or autotext.

Is there a way to retrieve an address automatically, if I type a doctor's name in the document?

Thanks, Vic
I use Mail Merge with the information in an Excel sheet. Letter is a new document based on a template linked to the spreadsheet.

"Find Recipient" and put in the last name of the doctor. Press Enter.
Name, address, greeting, all typed into the letter using merge codes.

Then I change it to a normal Word document (under Start Merge) and type your letter.
Reply With Quote