Hi guys. I'm trying to use Word mail merge with Excel to create mail labels and letters for each person on the list. For example,
Johnson, Michael
7391 Wilson Street
Van Nuys, CA 91405
I want to create a mailing label for this person. If possible, I'd like to make the top line of the address "Dr. Michael Johnson," however the format that I'm copying from is last name, first name. And I also want to want to create a letter that starts with "Dear Dr. Last name," such as "Dear Dr. Johnson." This is the website that I want to copy the addresses from:
ttp://doctor.webmd.com/local/california/los-angeles.htm
I have done my homework, but I don't know how to properly paste the addresses into Excel and then use Word to create the labels and letter. I have tried many ways, but I have been unsuccessful. What can you guys recommend? Thanks in advance!
Johnson, Michael
7391 Wilson Street
Van Nuys, CA 91405
I want to create a mailing label for this person. If possible, I'd like to make the top line of the address "Dr. Michael Johnson," however the format that I'm copying from is last name, first name. And I also want to want to create a letter that starts with "Dear Dr. Last name," such as "Dear Dr. Johnson." This is the website that I want to copy the addresses from:
ttp://doctor.webmd.com/local/california/los-angeles.htm
I have done my homework, but I don't know how to properly paste the addresses into Excel and then use Word to create the labels and letter. I have tried many ways, but I have been unsuccessful. What can you guys recommend? Thanks in advance!