I have a spreadsheet in Excel that I've put into Access that contains customer information, including their name and address.
However currently their address is listed as:
123 Fake St. Springfield, US 12345
Or maybe something like:
123 Fake St. Suite #3243 Springfield, US 12345
What we want to do though is create mailing labels by merging the Access data into a Word document and make it so that the format would be:
123 Fake St.
Springfield, US 12345
The only idea I have is to manually put a linebreak between the address and city for each mailing label, but we plan on sending this out to thousands of customers on a regular basis.
Is there any way to separate "address" and "city" so that I can put them on separate lines?
However currently their address is listed as:
123 Fake St. Springfield, US 12345
Or maybe something like:
123 Fake St. Suite #3243 Springfield, US 12345
What we want to do though is create mailing labels by merging the Access data into a Word document and make it so that the format would be:
123 Fake St.
Springfield, US 12345
The only idea I have is to manually put a linebreak between the address and city for each mailing label, but we plan on sending this out to thousands of customers on a regular basis.
Is there any way to separate "address" and "city" so that I can put them on separate lines?
Facebook
Twitter