Complex merge

[Dries]

Hi,

what I want to do is a kind of invoicing for a service
club, I'm treasuser of, so these are the three steps:

1) Merge data (from access) into a word document where
the difficulty is to put multiple records depending on
one field that changes or not (email-address)
2) Split up this document into different sub word
documents (again depending on the email-address)
3) send the different sub-documents to the different
email-addresses.

The problem now is that I do step 2 and 3 manually as I
merge in step 1 to a catalog with a method I found in the
knowledgeb-base.
The question is: is there any way to automate easily step
2 and 3 or even all steps?

Best regards,
Dries.

 

[Dries]

Hi,

to do the mail merge of the different subdocs to
different emails, if found a macro on mvp following the
link
http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachmen
ts.htm.

So that already solves point 3).

Now, I only have to find a solution for point 2.

Best regards,
Dries.