Multiple PDF In One Email

[bestfc01]

Hi All,

I need to send 6 reports into one email in PDF format.

I no i can do it through Macro, but the only coding i can find on here keeps saying i have an error.

Below is what im hoping for.

All these reports are linked to individual tables

I need all 6 reports to be send on one email, whilst only entering the P/O number once. To email address test @ test . com (not sure what actual email we will use yet so have put the above)

Table Name: H2216JFQJR

Report: H2216JFQJR
Report: Node QA

Table Name: Node 1 Main

Report: Node 1

Table Name: Node 2 Main

Report: Node 2

Table Name: Node 3 Main

Report: Node 3

Table Name: Node 4 Main

Report: Node 4

All of the tables have the field name of “Internal P/O” and ideally we would like to enter the PO number once and it automatically does this for each report. If this part isnt possible im not to worried.

 

[bestfc01]

Could i also add the send feature will be used by many users, so ideally it can be run without having to save the attachment first.