View Single Post
  #3  
Old December 10th, 2010, 05:18 PM
itinfoweb itinfoweb is offline
Member
 
First recorded activity by OfficeFrustration: Dec 2010
Posts: 2
Default

Quote:
Originally Posted by Gord Dibben View Post
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




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.