Remove Carriage Returns in Address Block Merge field
Hello to all,
I hope someone can perhaps please help with my problem.
I have exported some data that is in an access 2016 database to do a mailmerg.
One of the fields is an address "block", similar to below.
200 Any Street
AnyTown
PR23 4RT
This is in a mergefield "Address"
when I enter this merge field and complete the merge the "Address" field format is retained, I would like it to be all on one line as below;
200 Any Street AnyTown PR23 4RT
I have been looking for field codes or switches, unfortunately I cannot find what I need.
Could someone please offer some guidance
Thank you
|