add an attachment of an expanded attachment field as new record

[June7]

Okay, the example code given so far did not specifically show how to attach multiple files to same record, although clues are there. Here is another reference from same source offering that http://blogs.office.com/b/microsoft-...-a-folder.aspx



Basically, it again shows opening a recordset of the hidden child table of the multi-value attachment field but in this case the code loops through the files in folder and inserts each as a record in the child table - the reverse of looping through the child records to delete or save out to folder.

[aspen]

Dear Jun
The link is is so important and help full you know. And you have aided me personally to learn more vba about attachments than i ever imagined. when i started my first thread guessing that it was imposible , and i would just ask the forum and confirm a no and adjust. But this forum and specially jun7 has shifted my paradim of how vba can manipulate even attachments.

my eternal gratitude
thank you