I would like one macro to do the following;
Send the following email to the email addresses found in the range B86:B93 on the active sheet (saxon 03.07.2015) in the attached workbook.
Please could you complete the action points found on the supplier meeting report (link below).
Once you have completed your action points please change the status from the drop down list found in column C/D and leave any relevant comments in the STAKEHOLDER COMMENTS column.
Once completed please click the save & close button at the top of the page.
If you have any questions regarding your action points please contact the appropriate category manager found in cell "E6"
(insert meeting report hyper-link *see PHASE 2 below)
Supplier Relationship Team
Email subject = Supplier Meeting Action Points
Insert a hyper-link at the bottom of the email body sent to the all of the email addresses in the range B86:B93.
The hyper-link should send the recipient of the email to cell A1 of the active sheet where this macro will be run from.
The file path for the active sheet is P:\Supplier Relations\Supplier Meetings status.xlsm
I would like the link in the email to be displayed as the value found in cell B2 on the active sheet. (note: this value will change as values on the active sheet will vary).
Once the emails have been sent to the email addresses, cell B3 should be populated with report sent on: (TODAY'S DATE)
TODAY'S DATE = date the macro is run and the emails are sent.
The workbook should then be saved (not save as). The workbook should remain open.
1.If the same email appears twice in the range B86:B93 then only one email should be sent to that address. i.e. the recipient should only receive one email.
2. The active sheet will vary depending on the choice of the user. However the layout of the report will be exactly the same. The values will change depending on the users entries.
3. Note:all recipients will have access to the file path as they will be using the same server