Retrieving data from a list or database.
First of all, apologies if this has been addressed. I have spent ages looking for specific answers but can't seem to find what I am looking for.
In my profession, I am required to write letters to doctors with information about our mutual patients.
The beginning of the letter starts with the doctor's name and address.
Next the client's name and date of birth are inserted.
Then I write, "Dear Dr xxx, thank you for referring (patient's name)
What I really would like is to be able to type in the doctor's name at the start of the letter, and have the doctor's address appear automatically from lets say an excel file, without me having to go to to that file to physically select it.
I have attached the document.
Thanks, Vic
|