So I am trying to set-up labels, which are no problem and can merge over to microsoft word with no problem. The problem comes with the cell for First and Last name. Somebody else had all the information pulled from a database with three different colums (first and last name, address, and city, state, zip)
Example:
Smith, John --- Column 1
23 Nowhere St -- Column 2
Somewhere, NY, 13642 -- Column 3
I am able to merge these over with no problem, but these labels are going to be used to send out business promos, so having Smith, John as the first line doesn't look professional and is confusing. I was wondering if there was a way with a macro or module to get it to read John Smith instead.
Any help would be greatly appreciated. Thank you in advance.
Brandon
Bookmarks