Multiple fields from one datasource to multiple unique mail merge docs

[MikeB]

Using Access 2000 and Word 2000.
I have a table of students in classes with the class name
and dates. I need to generate a mail merge doc notifying
the students(probably printing) of course and date. the
record contains the course name and dates which need to be
on all letters but I need each of the students names
unique on each letter. I cannot get around seperating the
field data from the record but still maintaining the
record's order properties easily. I have been looking
through the old postings and I checked on Cindy's page
under the complex merges and can't see anything that
applies. I am not a pro and not green at Word, Access and
VBA. I am mainly looking to getting the data merged right
now and I will figure out how to automate printing. As an
aside, I am planning to try to have this happen via a
button on a form containing all of the data via VBA, kind
of one click printing. Is that even possible and does that
help making the task easier or make it more challenging (I
was trying to figure out if I could use the RunCommand
wdSendToNewDocument from Word in Access?!?) Sorry about
the long windedness, thanks in advance!!!!!!!

 

[Doug Robbins - Word MVP]

Hi Mike,

Can you try and make this a bit clearer by showing how the data is arranged
in the table, with and example of the data and how you want the data to be
arranged in the mailmerge document.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[MikeB]

I am fairly new to newsgroups and I realise you want the
questiones re posted on the newsgroup for others but it is
rather difficult to display the table data efficiently in
a text only window, I tried pasting a screen cap which, of
course, didn't work. The text box limits the ability to
see the data. It is pretty hard to display a number of
fields in columns, even only displaying a limited number
fields, due to the text box width. How would you recommend
I recifty this, shall I send you an HTML email and you
display it on the posting somehow? I don't mean to be
difficult but I think you can see what I mean. To explain
it, I need to show at least 8 columns and 1 row of the
table. If I had quick access to a webpage I could post it
with a link, unfortunately, that is not easily attainable.
Thank you in advance, Mike

I will try to explain it better if the above is not
possible.

 

[MikeB]

Thanks, I think that kb105888 is going to fix me up. I
will need to add an identifier field to my table, maybe
with a query, but I think I get the jist of it. Each
record of my table has three fields which need to be on
all ten MailMergeDocs and ten unique fields which need to
be displayed on the ten different Docs. Again, I am new at
Office programming and trying to fine tune an exsisting
database designed by someone else. Thanks again!