Hi word experts,

 I am creating mail merge to send mail to manager, i am getting recipient list from excel. I am having subordinate who working under manager..

 I need to send mail to manager with table in body with their subordinates name

Excel format

Manager Name   Subordinatename

ram                             peter

ram                            peter

ram                           peter

paul                            bush

paul                           ram

I have to send seperate mail to ram with 3 subordinates name in mail body and for paul same.

pls help me.

A mailmerge, per se, cannot create a table. The best a mailmerge can do is generate a separate table for each row, and grouping a series of records requires a directory/catalog merge, which doesn't work with emails. You can, however, generate a table using a DATABASE field in conjunction with an email mailmerge. Using a DATABASE field with a mailmerge requires a working knowledge of SQL. An alternative is to use one of the Many-to-One Mail Merge add-ins, such as the one available from MVP Doug Robbins at http://bit.ly/1hduSCB