Attach form to a table field?

[mantooth29]

I will start by explaining the big picture of what I am trying to do in case anyone has a better suggestion...

I am attempting to automate emails using a directory or many to one style mail merge.
The merge needs multiple pdf attachments inserted, and they are specific to each employee referenced in the email.

There is a main table that provides the data for this merge, but also the data for a forms database which is how the pdf's are generated.

My question is this:

Is it possible to put each individual form back into the main table as an OLE object, etc?

My thinking is that I can just make the pdf (or whatever file type it needs to be) another field in the mail merge.



I am comfortable with VBA if that would be required, although most of my coding is in Excel.

[June7]

First, I don't understand why you would want to put a copy of form in table. Second, I doubt can be done.