Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

create mailing labels from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eleanor - 23 Apr 2004 15:21 GMT
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 - 23 Apr 2004 20:46 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.