For EXCEL, you must put the name and address in one line of text with
like:

Joe Smith 123 main St., Huston, TX 11555

Highlight that text, copy it, and then paste in the AutoCorrect as I
explained in my previous post.

To load a large group of AutoCorrect data, read the other response to
my earlier post that provides a web address. It was very helpful
explaining the use of Macros to make it faster...but it is not easy.

For WORD, we entered all of the addresses in a long document manually
to do it. I believe you can export address info from your OUTLOOK
contact list into a database, then bring it into a using the Mail Merge
function as if you were doing to make labels.

Hope this helps.


--
Douglas23
------------------------------------------------------------------------
Douglas23's Profile: http://www.excelforum.com/member.php...o&userid=36177
View this thread: http://www.excelforum.com/showthread...hreadid=559564