Hi, I am trying to do the following:
Based on attached file,
- Open a folder whose title is based on current month (in format “MMMyyyy”) e.g. folder name “abc company apr2021”
- Open the attached excel spreadsheet titled “Name List”
- Find from the folder in (1) above, the payslip file (in pdf format) containing the name of staff. Format of the payslip will change depending on the month is as follows: “payslip-ABC Company-First Name-Last Name-YYYY-MM-END_MONTH.pdf”
- Attach payslip file in outlook and email to the respective staff according to the email in the attached excel
- Subject of email: “ABC Company MMMyyyy Payslip”
- Body of email:" Dear [Name], Please find attached your payslip for MMMyyyy. Let me know if you have any questions.
- If I currently have 2 emails in my outlook, how can I select 1 of them to send out the payslip email by default?
- Please share your XAML.
Name List.xlsx (9.6 KB)
Thanks a lot.