Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2013, 03:33 AM
Vic01 Vic01 is offline Retrieving data from a list or database. Windows Vista Retrieving data from a list or database. Office 2007
Novice
Retrieving data from a list or database.
 
Join Date: Nov 2013
Posts: 7
Vic01 is on a distinguished road
Default


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
Reply With Quote
  #2  
Old 11-09-2013, 10:57 PM
Charles Kenyon Charles Kenyon is offline Retrieving data from a list or database. Windows 7 64bit Retrieving data from a list or database. Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving deleted data charles Outlook 0 12-23-2012 10:58 PM
Easy send/save Excel data to Database Table or Stored Procedure TonyHarvard Excel 3 07-11-2012 12:43 PM
Retrieving content control value jillapass Word VBA 4 05-24-2012 05:07 AM
Retrieving data from a list or database. How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
Using data entered in prompt to search database table BluRay Word 1 03-25-2011 01:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft