Address block

[Renate]

I have all my data for mail merges in Excel. I do
frequent mail merges and I am now frustrated because I
cannot customize the "address block". since I work for a
religious organization, I need the title after the name.
If I go into "more", I can insert the name, but if I use
the space bar, I don't get a space but it inserts the
same name agains. In order to get the address as I need
it, I have to close the box, make my space then open the
box again for the next line, etc. until I have all the
merge fields in.
Can anyone help me with this problem?
Thanks.

 

[Mark Henri]

I have all my data for mail merges in Excel. I do

frequent mail merges and I am now frustrated because I
cannot customize the "address block".

Actually, you're question belongs in the Word forum. Excel has no mail
merge facility.

 

[David McRitchie]

Hi Renate,
Is your data in the form of a spreadsheet with *labels* across the
top. Those labels in row 1 might look something like

Phone | First name | lastname | address line ! City | ST | zipcode| datejoined

If your data is in columns but you do not have labels you will have a
dickens of time trying to figure things out.

Instructions to create address labels with Mail Merge (part of MS Word)
can be found in http://www.mvps.org/dmcritchie/excel/mailmerg.htm

While true that Mail Merge is MS Word, there are enough Word
people in the Excel groups that as long as you are using Excel
for you input you should be fine posting here. I think you are missing
the labels at the top of your columns, perhaps even missing the
columns.

Most Excel users have more than one worksheet in use in a workbook,
and the fact that Mail Merge (MS Word) will use the *first*
worksheet tab is a lot more likely to be encountered as a problem
by someone more oriented to Excel than to Word.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm