Hi
it's always best not to attach anything anyway
you can take the data directly from word to excel without retyping anything
to do this, select the file in word (always use a copy of the original file,
just in case)
and choose the whole document (Ctrl & A). Now i'm assuming that you have a
blank line between each address if so, do this
choose edit / replace
find: ^p^p
replace with: ###
(type this all in in lower case)
click replace all (and don't panic)!
now in the find type
find: ^p
replace with: ^t
(again all lower case)
and replace all (still no panicing)
now type
find: ###
replace with: ^p
click replace all
now all your addresses should be on a single line separated by tabs.
if you copy & paste this directly into excel in a new worksheet
you should end up with the data in different columns, except for the Doctor
John Smith bit which will all be in column A,
so insert a couple of columns between this field and the Title 1 field and
then select column A
choose Data / Text to Columns, click delimited, untick tab, tick space and
press FINISH. These three fields should now be split up for you. Check the
rest of the data to make sure the columns will line up and then you can copy
& paste this directly into your other excel list.
Once you've got everyone in there have a look at Chip Pearson's site on
working with duplicates
http://www.cpearson.com/excel/duplicat.htm
to get some ideas on how to check for an elimiate duplicates.
Once you've done this you can use your excel list as the data source for a
mail merge with word to produce mailing labels.
You might also like to ensure that your suburb and zipcodes are in different
fields to help with sorting etc down the track (use the Data / Text to
Columns) feature to assist with this also.
Hope this helps
Cheers
JulieD
PS i wouldn't bother going to access if all you want to do with the names is
print mailing labels.
