Mail Merge Using Albert Kallal

[Phil]

I am using Albert Kallal's Mailmerge which work well however I need to merge
data from more than one query to the word document is there anyway to do this?

I cannot get 1 query to have all the data I need at the moment I use

Dim strSql As String
strSql = "select * from ACSTMailMerge where Eventid = " & Me!EventID
MergeAllWord strSql



hope someone can help

Thanks

Phil

 

[pietlinden]

I am using Albert Kallal's Mailmerge which work well however I need to merge
data from more than one query to the word document is there anyway to do this?

I cannot get 1 query to have all the data I need at the moment I use

Dim strSql       As String
strSql = "select * from ACSTMailMerge where Eventid = " & Me!EventID
MergeAllWord strSql

hope someone can help

Thanks

Phil

You're leaving out a lot of information. How are the data sets
related? Is one the "one" side and the other the "many" side of a one-
to-many relationship? Can't answer until I know more. If I'm right,
though, then you can't use Albert's code. The way it was done in ADH
was to use bookmarks and use automation to send the child records as a
delimited string and then convert that to a table
using .ConvertToTable in Word.

 

[Phil]

Sorry, I have an events database with tables:

Attendees AttendeeID 1 to many with Registration table
Registration
Events Event ID 1 to many with Registration ID

That my initial query pulls Attendees from the registration table on an
event based on EventID.

I also have a list of people who facilitated the event the tables are

Facilitators FacilitatorID = 1 to many with Faciliator registration
Facilitatorregistration =
Events (As above table) EventID 1 to many with facilitatorId

If I generate a query to give me all attendees and facilitators i get double
attendees because each course has a minimum of 2 facilitators which really
messes up the mail merge.

Now ideally I would actually do this in a report, but I need to use the Word
document I have been supplied with as the recipients will be pulling the data
into their database which is expecting the dfata in a specific format.

Hope you can help

Thanks

Phil

 

[Phil]

sorry only answered half the problem, I use the query to add attendees to the
word document, but also need to add facilitators not sure how to do this may
just have to manually type them in

Thanks

phil