 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Labels and excel
Hi I have an excel sheet that I keep as a log, it looks something like COMPANY NAME, SERIAL#, TEST PRESSURE, TEST DATE, PART NUMBER under the heading goes the data, but now I need to print each line off as a label to attach to the equipment we sell (very small pipes and equipment for oil rigs) is it possible to print each line of data and the headings (above) as a single label? I want to pick a line of data and use the headings to print one label or many for different bits of equipment or am I asking to much? I use Excel 2007 also 2003 help in either would be great. Please be as kind and as simple with your replies and if you ever need a mechanical engineer I am your man :-) thanks Gordon Excel alone is poorly suited for this task. Word is much better for labels and envelopes using Excel as the source for the labels. Assuming you are using Word for the mailmerge and Excel for the source see these sites for help. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm Gord Dibben MS Excel MVP >Hi > I have an excel sheet that I keep as a log, it looks something like [quoted text clipped - 16 lines] > >Gordon http://savefile.com/projects/808609774 Hi SoundBytes Find attached link to sample that you referred to, its possible to do but not practical if your list is long. To use it you just need to "remove Set print Area" select the next row and do a "Set print Area" ,your Heading will be on each print, see print preview. Like Gord said its not very practical if you have a lot of info to print. Regards Cimjet > Excel alone is poorly suited for this task. > [quoted text clipped - 39 lines] >> >>Gordon Hi Thanks for your hard work, the sample and links, I got there in the end once again thanks :-) Good to hear. Thanks for the feedback. >Hi > Thanks for your hard work, the sample and links, I got there in the end > >once again thanks :-) |
Reply to this Message |
 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.