Hi, i am looking for a macro/add-in which when run, prepares an email (by using certain fields provided in excel sheet) and prompts for a location for that excel sheet to be attached. The message body should contain
"
Dear All <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
We have received a centralized settlement for for master policy _____________ . Attached below is the spreadsheet, which shows the premium allocation, policy numbers and amounts that you will receive. We have also updated the banking details and genius account codes in the sheet. Please advice of any discrepancy as soon as possible.<o></o>
We are in the receipt of the cash and we will advise you individually to confirm when the wire transfer has been completed. <o></o>
If the cash received does not match the premium entry processed on Genius, please query this with your local PAM.<o></o>
I would like to thank you in advance for your assistance."
Please can anyone help?
"
Dear All <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
We have received a centralized settlement for for master policy _____________ . Attached below is the spreadsheet, which shows the premium allocation, policy numbers and amounts that you will receive. We have also updated the banking details and genius account codes in the sheet. Please advice of any discrepancy as soon as possible.<o></o>
We are in the receipt of the cash and we will advise you individually to confirm when the wire transfer has been completed. <o></o>
If the cash received does not match the premium entry processed on Genius, please query this with your local PAM.<o></o>
I would like to thank you in advance for your assistance."
Please can anyone help?