If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
I need to say, as much as I enjoyed studying what you had to say, I couldnt help however lose curiosity after a while. Its as should you had a great grasp on the subject matter, however you forgot to include your readers. Maybe it is best to think about this from more than one angle. Or perhaps you shouldn't generalize so much. |
Thread Tools | |
Display Modes | |
|
|