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 / December 2007

Tip: Looking for answers? Try searching our database.

Creating lists with mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mad-asian - 13 Dec 2007 20:54 GMT
I want to create a mail merge that will generate a list in word. For
example, I have an excel spreadsheet that lists my students' names and
various other information. My class roster changes daily, so I need to
print out a new class list everyday. I want word to generate a class
list based on the Excel fields I use in the merge. Basically, I don't
want one page per student. I want all of my students listed on the same
page along with their student IDs, DOBs, etc. I also need to have hard
coded text above and below the list.

Is this possible?

Signature

mad-asian

Peter Jamieson - 14 Dec 2007 09:33 GMT
It's harder than it ought to be.

The problem with doing this using MailMerge is dealing with this bit,
especially if you want your data to be in a table. If you have Access, you
should definitely consider Access reporting for this.

> I also need to have hard
> coded text above and below the list.

One way to deal with it is to have two documents:
a. a mail merge main document (use the "Directory" type mail merge) that
generates the list that you want. Use this to merge to a new document which
you will always save as myoutput.doc
b. a second document that contains the hard coded text above and below, and
uses an INCLUDETEXT field to include myoutput.doc in the middle.

Then, do the merge, save myoutput.doc, open the second document, select the
contents (e.g. ctrl-A), press F9 to execute that INCLDETEXT field, and you
should have your document.

Another possibility if the layout can be simple and tabular would be to use
a DATABASE field to insert the Excel data, rather than doing a mail merge.
This would be similar to the document in (b) but instead of that INCLUDETEXT
field, you would have a DATABASE field that specifies the Excel sheet as the
data source, specifies which columns you want, the sort order and some basic
table format options. In this case you would open the document, select the
content (e.g. ctrl-A), press F9 to execute that DATABASE field, and you
should have your document.

You can insert a DATABASE field using the DATABASE toolbar (try
View|Toolbars to enable it) and ensure you check the Insert as field option
at the end of the dialog. However, DATABASE fields do not always work as you
might expect - sometimes they can be fixed by modifying the field code
manually, and sometimes they cannot.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> I want to create a mail merge that will generate a list in word. For
> example, I have an excel spreadsheet that lists my students' names and
[quoted text clipped - 6 lines]
>
> Is this possible?
 
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.