Dear all,
I have to mail merge a customer list in excel in which the names will vary according to each region. I knew this has to be accomplished via directory mail merge. However, I am a novice and do not know how to achieve it.
1. Region
2. am customer name
3. am customer title
4. pm customer name
5. pm customer title
The original data comes in by one region one row with the above append across different columns. Due to the format of a directory, I think I have to convert them into the one as attached first.
The above are the headings of a table with the text in the region column to be a merged cell. I have tried to use the field codes but the names under one region would separate into different pages under the existing codes. Please advise. Thanks!
Bookmarks