Keren has attended:
Excel Intermediate course
Word Advanced course
Mailmerge
How do you prevent unwanted spaces appearing when setting up letter mailmerge? i.e when adding your own address fields manually.
RE: Mailmerge
Hi Keren, thanks for your query. Very much a trial and error thing this. When you are inserted your merge fields you can never quite account for addresses which miss a line or don't have a post code. Two solutions, make sure your source data has a value for every potential merge field, and secondly, you could write a macro to "clean" the documents after the merge, searching for unwanted paragraph marks and deleting them out althought that is even more fiddly!
Hope this helps,
Anthony