Yes, the 'addresses' I currently have are in 'paper format'. All of the
letters follow the same format, for the most part. The only difference is
that sometime the 'suite' number is on the same line as the address. How
could I create a macro to create this? The basic's of the letter are as
follows:
May 29th, 2009
Dr. John Smith
890 S Washington
Suite 201
Grandville, MI 49418
Jane Doe DOB: 01/01/1950 DOS: O5/09/2009
Dear Dr. Smith:
This is the basic format of the first few lines of the letters. Again,
sometimes the 'suite number' will be on the same line as the addresses.
Thanks much for your help
Michelle
"Graham Mayor" wrote:
By far the easiest way to do this would be to get the addresses into an
Outlook contacts list. In order to do that you need the addresses in the
form of a list that can be imported into Outlook. It appears that your
'list' is in a paper book? You do, however, appear to have the addresses in
your store of letters on your hard drive. If the letters are all identically
formatted with respect to the addressee information, it should be simple
enough to create a macro to trawl through the letters, extract the
addresses, sort and eliminate duplicates. Can you let us know how the
documents are laid out?
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
kniblet0125 wrote:
Hello!
If ANYONE can help me out with this, I will do anything to 'pay you
back'.
Here is the situation. I type letters for a Doctor's office (not
transcription trained, medically trained and mostly computer
literate). The BIGGEST 'bottleneck' to my efficiency is looking up
the Doctor's addresses. I have a huge book that contains all of the
addresses. I have been doing this for almost a year and hence, have
over hundred thousand letters I have typed. Most of them are to the
same 1500-2000 physicians.
Hence, I am looking for a way to 'insert address' into the letter. I
think there is a way that I can create my address book in word, then
insert. If you could tell me if this is possible that would be great!
However, it seems that I would have to 'physically' type in all of the
addresses specifically to the address book in word. THE IDEAL
SITUATION: anyway you know of that I could go through the previously
typed documents and click next to the address and 'insert into
address book'. (very similar how you click next to the address in a
document and can print an envelope). PLEASE HELP!
Thanks!
Michelle
IS THERE A WAY TO DO THIS?