vba code to print off the files stored in listbox

[aman]

Arnelgp, to ellaborate please see attached my table.

So I want to buid a form so that when i click print button then it checks ActivityRef and FormRef in the table . The table can have same ActivityRef more than once because that means more than 1 file is attached to that ACtivity Ref . SO basically print off a word document that will have Activity Ref, Form Ref and File names .

If the same ACtivity Ref is present more than once in the table for same FormRef then print just one word document followed by actual files.

This will help us distinguish which files belong to which ACtivityRef and Form Ref.

 

[arnelgp]

Hello aman, i downloaded the xl file, but its late here in my place. I will look into it tomorrow. If nobody resolved this by then, i will give you my feedback.

 

[aman]

Arnelgp, any update on this?

 

[arnelgp]

please explain further. where is the word document? will it be created on the fly?

 

[aman]

Arnelgp , thanks for getting back.

It will be nice to create word document on the fly? Word document basically is a header page that gets displayed before the files related to that Activity ref get printed.

So basically create word document and display Record ID (ActivityRef), Form name and the names of the files attached to it, print off the word document and close it and then print off those files related to that Record ID .... this process will go on for all the Activity References.

 

[aman]

Or i can save a word document somewhere with merge fields which can be opened,printed and then closed and then the files get printed ?? can this be done?

 

[arnelgp]

hey aman can we use Access Report instead of Word doc for the printout of Cover letter?


I noticed there is only 1 Form Ref. Does this mean that this is a Group and those 8 files belongs all to Form Ref=24? If so, then After printing the First Report with Activity, FormRef, Filename, 8 files will be printed after, right?