Reply
 
Thread Tools Display Modes
  #1   Report Post  
mad-asian mad-asian is offline
Junior Member
 
Posts: 1
Default Creating lists with mail merge

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Creating lists with mail merge

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.

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

"mad-asian" wrote in message
...

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?




--
mad-asian


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print the lists I have created in mail merge? Sole Therapy Mailmerge 1 December 7th 06 10:38 PM
mail merge, combine address lists LYNN80123 Mailmerge 1 October 19th 06 03:38 PM
How do you combine several mail merge lists into one? lisabeth Mailmerge 1 October 11th 06 03:51 PM
combining lists in mail merge visiondoc Mailmerge 2 September 27th 06 06:50 AM
Mail Merge Lists Ashley Mailmerge 1 September 23rd 05 09:23 PM


All times are GMT +1. The time now is 10:43 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"