D
Deleted member 146202
Guest
Hi all,
I'm coming to the end of a project (I think), and for one of the final tasks I want to email two forms as pdf's with the click on a button (open it ready to press send anyway).
Context:
My database stores logistics information and from the main data-entry/viewing form you can press two buttons to see the data presented neatly in two other A4 size forms for printing/emailing. (to send to hauliers).
However, rather than going into these forms, clicking email, waiting, and then combining the PDF's into one email, I'd love some help on how VBA can allow me to send them both in one email with one click of a button.
Also, if there would be a way to combine the two PDF's into one?? that would be amazing... but I don't know if that's possible.
Edit:
I have a button ready that opens an email, and uses a dlookup to fill the recipient from a table, as well as creates the title from some table data too... but when I add an attachment it doesn't do the 'WHERE "[Order Number ] = " & [Order Number] type thing that I've come to expect. It opens all of the records in that form and so obviously it's useless. Also there's only space for one attachment in the style I've done it as.
I'm coming to the end of a project (I think), and for one of the final tasks I want to email two forms as pdf's with the click on a button (open it ready to press send anyway).
Context:
My database stores logistics information and from the main data-entry/viewing form you can press two buttons to see the data presented neatly in two other A4 size forms for printing/emailing. (to send to hauliers).
However, rather than going into these forms, clicking email, waiting, and then combining the PDF's into one email, I'd love some help on how VBA can allow me to send them both in one email with one click of a button.
Also, if there would be a way to combine the two PDF's into one?? that would be amazing... but I don't know if that's possible.
Edit:
I have a button ready that opens an email, and uses a dlookup to fill the recipient from a table, as well as creates the title from some table data too... but when I add an attachment it doesn't do the 'WHERE "[Order Number ] = " & [Order Number] type thing that I've come to expect. It opens all of the records in that form and so obviously it's useless. Also there's only space for one attachment in the style I've done it as.