Using spreadsheet to mail maerge a paragraph of names

B

Brad Lansinger

I have a list of board members that updates regularly in
excel spreadsheet. I do my monthly mintes from the meeting
in word and have everyone's name at the top of my word
document in a paragraph format (showing that they were
present). It appears that I have to enter <<Nextrecord>>
next to each name to continue the names. This would mean
that if I added a person & forgot to add a next record for
that name to come in it would not populate, right?

Is there a way to get the names to all populate next to
each other without having to enter the exact amount of
<<next records>>? I would like to be able to simply update
the names in one place & have them auto update on all of
the documents that are connected to that spreadsheet?
 
G

Graham Mayor

The simplest way to achieve this would be to create a catalog/director merge
of just the information you require (the name list) to a new document, then
include that document in the minutes merge as an includetext field.

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top