fill in blank information
Hello:
I am going to try to explain this as much as possible as I can to make it sense. I have a form in word would like to merge the data from excel that I have created. In the data there are 3-different mailing addresses set in 3 different columns (mailing 1-plan type; mailing 2-address or attn.; mailing 3-address) then there is city, state, and zip have each it's own column as well. Mailing 3 column has few of the addresses are on this column because mailing 2 may have their attention name on it. When mailing 3 is pulled from the data to the form it is showing blank but what I wanted to do is pull/fill it in the next information which is the city, state, and zip. When the city, state, and zip are moved up to the mailing 3 line then the last line would be left blank. Can someone please help me. I hope this make sense. I have attached the form the way it is set up.
|