Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i set up excel to print envelopes from selected cells
I am using excel 2003 and i have a spread sheet in which i have columns with
names, addresses, & postcodes. i have used insert function to concatenate the cells to put the address in to one cell but i cant work out how to send it to prnt as a address format on an envelope in word easily by ticking a box Please help, WURZCLIFF2010 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i set up excel to print envelopes from selected cells
Can't see your layout, but mailmerge likes to see all info for each label
across one row in individual cells under titles like below. Name | StreeetAddress | City | State | Postcode 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 Gord Dibben MS Excel MVP On Fri, 21 May 2010 14:45:01 -0700, WURZCLIFF2010 wrote: I am using excel 2003 and i have a spread sheet in which i have columns with names, addresses, & postcodes. i have used insert function to concatenate the cells to put the address in to one cell but i cant work out how to send it to prnt as a address format on an envelope in word easily by ticking a box Please help, WURZCLIFF2010 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you print envelopes using an excel spreadsheet | Excel Discussion (Misc queries) | |||
how do i print from excel to envelopes | Excel Discussion (Misc queries) | |||
How do I print envelopes from an excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I print addresses onto envelopes from excel? | Excel Discussion (Misc queries) | |||
print envelopes from excel data | New Users to Excel |