Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Using spreadsheet to mail maerge a paragraph of names

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brad Lansinger - 15 Apr 2004 17:23 GMT
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?
Graham Mayor - 16 Apr 2004 08:30 GMT
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.

Signature

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

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

> I have a list of board members that updates regularly in
> excel spreadsheet. I do my monthly mintes from the meeting
[quoted text clipped - 10 lines]
> the names in one place & have them auto update on all of
> the documents that are connected to that spreadsheet?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.