I have a mail merge that adds in doctor's names from an excel sheet into a word file. The excel sheet does not have the doctors credentials only the first and last name.

I have entered the credentials in autocorrect so if John Smith is typed it will autocorrect to John Smith, MD or whatever the appropriate credentials are.

When I mail merge Word does not recognize and automatically insert the autocorrect function unless I manually hit space after each doctor name. This is a long list so it is time consuming to hit space after each one. Is there a way to automate this?

Thank you

This is a very strange way of going about things. Why not either: (a) include the credentials in the data source; or (b) use field coding to add them as the merge executes.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm sorry if that is strange but it has been the only way I can figure out how to do it. I am a transcriptionist. The excel sheet comes from the office I contract with who won't add the credentials. They have given me a list of the credentials which I have entered autocorrect so I don't have to look them up over and over. The list is very lengthy.

Previously I just typed the doctor information in and autocorrect would add the credentials using autocorrect. I am now importing that information using mail merge which is working great except I have to hit space to get it to add the credentials.

Thanks for your thoughts. Maybe its just a crazy idea!

So how do you know who has the credentials?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Every name in that column has credentials. I just have to add them in.

So why not insert the MD instead of @?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Because they are not all a like. For example they may be DO, NP, FNP, RN, etc.

In that case, you should create an Excel file with a list of names in once column and credentials in another. Then, when you get a new list from the client you can either:
a) use a lookup formula to retrieve the credentials for each entry and add them to the new file before merging; or
b) use a DATABASE field in the mailmerge to query the credentials workbook for the credentials that go with each name.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you. I will work on creating that and then seek further help. Sounds like a great idea.

Cross-posted at: http://answers.microsoft.com/en-us/o...8-5ac6b6a70309
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]