Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
I have MS Office 2007. I have my mailing lists in an Excel file and what to
download/convert it so that it will print mailing labels. I use Avery 5160 labels. How do I get the data from Excel and get it to download into Work or Access to print out sheets of labels? I am very inexperienced with Access. I want an idividual label for each person. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
See Word Mail Merge in Word help. Excel is just the data file.
green wrote: I have MS Office 2007. I have my mailing lists in an Excel file and what to download/convert it so that it will print mailing labels. I use Avery 5160 labels. How do I get the data from Excel and get it to download into Work or Access to print out sheets of labels? I am very inexperienced with Access. I want an idividual label for each person. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
Use Word's mailmerge...........labels and envelopes.
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/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm Make sure you have a few sheets of sticky labels available for printing. Gord Dibben MS Excel MVP On Mon, 2 Feb 2009 14:24:01 -0800, green wrote: I have MS Office 2007. I have my mailing lists in an Excel file and what to download/convert it so that it will print mailing labels. I use Avery 5160 labels. How do I get the data from Excel and get it to download into Work or Access to print out sheets of labels? I am very inexperienced with Access. I want an idividual label for each person. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
Make sure you have a few sheets of sticky labels available for printing Test on Plain paper first; it's cheaper :) -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57735 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
mdmackillop wrote: Make sure you have a few sheets of sticky labels available for printing Test on Plain paper first; it's cheaper :) You forgot to tell them they need a printer. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
I have struggled with this for years. I have an old printer and the labels
are on a roll. It works fine with a BASIC program and an ancient PC machine, but I can find no way with Excel or Access of controlling line-print, rather than sheet printing as with Office. Can anyone help me with this one... Thanks Robin... "Bob I" wrote: mdmackillop wrote: Make sure you have a few sheets of sticky labels available for printing Test on Plain paper first; it's cheaper :) You forgot to tell them they need a printer. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print mailing labels from an Excel file?
Just a thought but have you properly set up the printer configuration in
your operating system to handle the continuos feed paper and defined the paper page size to match the label. Robin wrote: I have struggled with this for years. I have an old printer and the labels are on a roll. It works fine with a BASIC program and an ancient PC machine, but I can find no way with Excel or Access of controlling line-print, rather than sheet printing as with Office. Can anyone help me with this one... Thanks Robin... "Bob I" wrote: mdmackillop wrote: Make sure you have a few sheets of sticky labels available for printing Test on Plain paper first; it's cheaper :) You forgot to tell them they need a printer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can we print mailing labels from a Excel spread sheet? | Excel Discussion (Misc queries) | |||
How do I print mailing labels in Access and Excel? | New Users to Excel | |||
Can you print mailing labels from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
how do I print mailing labels from an Excel database? | Excel Discussion (Misc queries) | |||
How do I print mailing labels in Excel 2000? | Excel Discussion (Misc queries) |