Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we print mailing labels from a Excel spread sheet?
We have an Excel spread sheet with names and addresses...we want to print
mailing labels...any idea |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we print mailing labels from a Excel spread sheet?
Assuming you also have MS Word, use the Mail Merge function and select your
Excel spreadsheet as the data source. Regards Trevor "Doreski" wrote in message ... We have an Excel spread sheet with names and addresses...we want to print mailing labels...any idea |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we print mailing labels from a Excel spread sheet?
Doreski
I suspect you don't have a single record in rows do you? e.g. First Last, Add1, Add2, Town, PostCode in A1:F1. If you do, use MSWord mail merge functionality and the Excel workbook as the data source. (Just make sure it's either single sheet or the leftmost one) If the data is in rows, then you really need to get it into columns...maybe we could help with some code to automate this if the data has some uniformity, e.g always 6 rows with a space. (Normally wishful thinking!) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Doreski" wrote in message ... We have an Excel spread sheet with names and addresses...we want to print mailing labels...any idea |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we print mailing labels from a Excel spread sheet?
Excel alone is poorly suited for this task.
You can, by trial and error print labels, but Word's mailmerge function is much easier. For help on Word mail merge using Excel or Access as the data source. 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 Gord Dibben MS Excel MVP On Tue, 17 Oct 2006 13:34:02 -0700, Doreski wrote: We have an Excel spread sheet with names and addresses...we want to print mailing labels...any idea Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print mailing labels in Access and Excel? | New Users to Excel | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Can you print mailing labels from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Excel Slow to open Spread Sheet from Explorer | Excel Discussion (Misc queries) | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) |