Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.newusers
Stephen Glynn
 
Posts: n/a
Default Access query as a mailmerge source

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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mailmerge from Access parameter query only merges odd records helios Mailmerge 5 December 30th 05 11:24 AM
Mailmerge Query - Works in Access; fails in Word Gary Stark Mailmerge 4 October 6th 05 07:57 PM
Mailmerge from access database where query contains "fieldname like 'text*'" Kroese, Ramon Mailmerge 2 August 4th 05 05:03 PM
How to use access query computed fields in Word mailmerge Rey Mailmerge 5 June 23rd 05 06:26 PM
Mailmerge data source in an Access database will not open Colin C Mailmerge 3 December 31st 04 12:01 AM


All times are GMT +1. The time now is 05:22 PM.

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

About Us

"It's about Microsoft Word"