Attached are two excel workbooks "master_query_log" and "query1".
Currently when the "import" button in the master query log is clicked it will allow the user to select the relevant query file e.g. "query1". Once selected the information will automatically be copied and pasted into the bottom row of the the master query log under the appropriate column headings.
I would like to add another step to the macro.
When the "import" button is clicked and the file is selected. I would also like the macro to automatically send an email to the email address is column F of the master query log.
The body of the email will include the following.
Member Name: RS Industrial Services Limited
Supplier Name: Guardsman Ltd
Value on Query: £247.63
Query Ref.: Q327
Supplier Invoice No.: 46/132603
Date THS HQ Logged Query: 14/04/2015
Subject: Invoice Query Acknowledgement
Note this includes information added once the sheet has been pasted into the master query log.
UID = Query Ref.:
Date THS HQ Logged Query: = HQ Input Date
If any one is able to add the coding to the sheet and reattach that would be great.