merge more than one record at a time 1

[WebGodiva]

I need help. I've got a module i'm running from a form which access a query and then takes that data and runs a word merge with a predetermined document.

My problem is I want to be able to select more than one refrence number (employee id) and have all information for 2 or more employees merge in different letters with the push of one button so my user doesn't have to keep going back and forth (they can select a grouping). It works great with one employee..but when you select two employees, it dumps all of the selected data from both employees onto one form. In other words if i pick Jon Doe and Jane Smith, I want both records to merge but to different letters. What is happening now is Jane Smith's records are merging at the bottom of Jon Doe's.

the module is as follows:

Function Merge_It()
Dim objWord As Word.Document
Set objWord = GetObject("H:\Database\resumes\Insp_Blank_merge.doc", "Word.Document")
' Make Word Visible.
objWord.Application.Visible = True
' Set the mail merge data source as the RESUME database.
objWord.MailMerge.OpenDataSource _
Name:="H:\Database\resumes\Master_res.mdb", _
LinkToSource:=True, _
Connection:="QUERY InspWthProjectsSelect", _
SQLStatement:="SELECT * FROM [InspWthProjectsSelect]"
' Execute the mail merge.
objWord.MailMerge.Execute
End Function

I would also like it to close the first instance of word (the master merge document) and just leave the letters1.doc open for the user to use - is there away to do that.

Any and all help would be appreciated.



"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

 

[Remou]

There are a several FAQs on mailmerge. This one:
'Native' mailmerge reports - as painless as possible
faq181-5088
May suit.

 

[WebGodiva]

thanks, i'll give it a try - a lot of code to go through - i'm just learning so it will take a while - i do truly appreciate your help.





"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

 

[Remou]

I think you will find that it is easier than it looks at first glance. This:
Creating Word documents for multiple records
thread702-1167168
Has some notes on the FAQ that may (or may not) be useful.

 

[WebGodiva]

Thanks - it's works great!!

i can stop banging my head now...i guess working with three seperate databases is too much for me right now....need to take it one step at a time.

again, much appreciated..



"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn