Allan,
Good morning! Your problem sounds very simple... yet a bit tricky. I am assuming that you know how to create a document for mail merge. However, I'm not sure if you can pass a recordset directly to a mail merge document (still something i have to research on myself). For the mean time, you'll have move the data to a format recognized by a mail merged document like (excel, word table, or a comma delimited text file) I suggest creating a mail merge document using the text file as your source. You can then move the contents of the recordset to the text file and then run the word document from VB.
You could play around with this for the mean time. I'll try to point you to some links with a more direct approach as soon as i get them.
Hope this works for you...
Martin
Shit happens!!!