I currently have an access based PO system that we send purchase confirmations to vendors. I build purchase conformation. Inside the form I have a field for email address. With that field, I place the email address of who the vendor is. When I send my Vendor conformation, I use a report to pull up all the purchases I have made using that PO. Within the Report Confirmation I have a macro set up that will automatically convert the PO into a PDF and attach it to an email. What I would like to do- if it’s not too difficult, is take the email address that I already have put in my form (and shows up on the Purchase Conformation Report) show up on my email. So when I click the button “Send to Vendor”
My outlook opens, with a PDF attachment of the Purchase Conformation, with the email of the Vendor already put in.
Is this doable?
Thanks for all the help!