I have been using microsoft word to mail merge letters to send to my
customers. I use Access data bases which I sometimes import from Excel as my
data sources. Up until now I have been inputing data myself, which takes
forever. Recently I discovered several data bases I can purchase that would
be very helpful to me. Unfortunately the data is not set up the way I need
it to be for my letters. My question is, "If the data is all in capitals,
can I somehow change the settings for the whole database so that only the
first letter of names, cities, and states will be capitalized?" I am using
Excel 2002. Please let me know if you have any ideas. Thanks