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

On Aug 12, 8:44*am, Phil <P...@discussions.microsoft.com> wrote:
> 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.

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




"pietlinden@hotmail.com" wrote:

> On Aug 12, 8:44 am, Phil <P...@discussions.microsoft.com> wrote:
> > 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.
>

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

"Phil" wrote:

> 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
>
>
>
>
> "pietlinden@hotmail.com" wrote:
>
> > On Aug 12, 8:44 am, Phil <P...@discussions.microsoft.com> wrote:
> > > 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.
> >