Hello,
I have an excel spreadsheet that is set up for a mail merge with all required fields included. The addresses are for the headquarters of companies, there is an additional field that includes the state that the companies need to resubmit a tax excemption cert. for. The letter I will be sending to the companies is pre-written with the only blank spot being where the states the certificate needs to be submitted for goes. My question is as follows: Is there any way to have the word document auto populate the "state needed" section based on the company name that is present in the excel document as well as on the top of the letter.
Thank you,
Additional Info: I have word 2007 as well as excel 2007
I have an excel spreadsheet that is set up for a mail merge with all required fields included. The addresses are for the headquarters of companies, there is an additional field that includes the state that the companies need to resubmit a tax excemption cert. for. The letter I will be sending to the companies is pre-written with the only blank spot being where the states the certificate needs to be submitted for goes. My question is as follows: Is there any way to have the word document auto populate the "state needed" section based on the company name that is present in the excel document as well as on the top of the letter.
Thank you,
Additional Info: I have word 2007 as well as excel 2007
