create mailing labels from excel

[Eleanor]

I need to mailmerge and create mailing labels from an excel spreadsheet. The spreadsheet is layed out in columns with the normal headings, company name, first name, last name.... I need to mailmerge a letter and labels to only the people with specific titles. For example, under the "company" column there are 7 rows for "The Smith Co." within these 7 rows are the listings for the president, senior vp, vp....; my mailing is going to presidents only....how do i separate the data in excel to create mailing labels to the president only. As you can tell, I am very new to the Excel program and am totally lost!

 

[Rhonda]

The easiest way to do it is to go into excel and sort by their title, then highlight them and set the print area. When you go back to your mailmerge, it should pick up those in the print area.