Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.newusers
|
|||
|
|||
![]()
I understand how to use an Access query as a data source, but how do I
handle it when my query is going to return an indeterminate number of results in particular fields? For example, if I'd written a query that returned the names and addresses of all students in a year and the courses for which each student was enrolled, how would I do a mail-merge to send an individual letter to each student confirming the courses? Would I have to insert fields to accommodate the maximum number of courses for which a student could possibly be enrolled, and then let Merge suppress blank lines if a student wasn't carrying a full course load, or is there a neater way to do it? I can understand how I could use bookmarks to send such a letter to particular students whom I'd selected using a form in Access but I'm not sure how I could get that to work so I could send the letter to all the students at once. Or should I be asking this in an Access group? Steve |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
mailmerge from Access parameter query only merges odd records | Mailmerge | |||
Mailmerge Query - Works in Access; fails in Word | Mailmerge | |||
Mailmerge from access database where query contains "fieldname like 'text*'" | Mailmerge | |||
How to use access query computed fields in Word mailmerge | Mailmerge | |||
Mailmerge data source in an Access database will not open | Mailmerge |