Hi Helpers,

I have an excel sheet which contains following column titles:

Post Date of Interview Venue Applicant Name

Sample Data:

Clerk 12/04/16 Main Hall Mr. XYZ
Helper 15/04/16 Central Hall Mr. XYZ

and so on.


It means that one person may have applied for multiple posts. There is no restriction for that.

So, I have different number of rows for different applicants. e.g. Mr. XYZ have applied for 3 posts so 3 rows for him. Mr. ABC may have applied for 5 posts, so 5 rows for him and so on.


Now I want to do mail merge for all the applicants to intimate them about post applied for, date of interview and Venue in a tabular form along with some fixed information like some instruction and their name to be printed only once in a letter.

In my case, Mr. XYZ's letter will contain a table with 3 rows and Mr. ABC's letter will contain 5 rows.

Is is possible in mail merge with data in excel?

If yes then how? Please help me.

Thanks in advance.

Jaggu