mail merge from Excel - need static fields

[ps56k]

I've been able to create a Word 2007 merge for mailing labels
using the source data from our school team Excel 2007 file of names.

The resulting labels basically show a <addressblock> placeholder,
and the actual previewed labels print/display fine for use with the 3x10
standard labels.

However - since everyone in our list is "local",
how do we get a "mailing label" image
when we need to add static information such as City, State, & zip
along with the "," coma separation. ?

tnx for any pointers -

 

[Graham Mayor]

Avoid the use of the Address Block field and use the individual fields that
make up the address in the manner that you require -
http://www.gmayor.com/merge_labels_with_word_2007.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[ps56k]

tnx - I've saved your webpage info....

BTW - another little nit - how do I get the "cells"
to display their edges/borders ?
All I have is the little squished box, but no table/cell outline ?

 

[ps56k]

ok - found the -> Table Tools -> Layout -> View Gridlines

next.....

how is the "padding" in the label actually accomplished ?

I don't see any spaces, tabs, or other indents ?

GREAT - it's under the normal Page Layout -> Paragraph Indent/Spacing

I really hate the 2007 menus,
and have purchased an add-on that gives me back the old menus
so I can get the work done without constantly trying to figure out the new
menus....
http://www.addintools.com/