Reply
 
Thread Tools Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP
 
Posts: n/a
Default Access query as a mailmerge source

I would use and Access Report, not mail merge.

But, if you want to use mail merge, See the "Group Multiple items for a
single condition" item on fellow MVP Cindy Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default...b;en-us;211303

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Stephen Glynn" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.newusers
Stephen Glynn
 
Posts: n/a
Default Access query as a mailmerge source

Thanks, Doug. Those resources look exactly what I need. An Access
Report, though, does, as as you suggest, seem the best way to do it,
even though they're a pain in the neck to lay out as letters.

Thanks again.

Steve


Doug Robbins - Word MVP wrote:
I would use and Access Report, not mail merge.

But, if you want to use mail merge, See the "Group Multiple items for a
single condition" item on fellow MVP Cindy Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default...b;en-us;211303

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
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 08:19 AM.

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"