The organisation I work for has a PayPal account to accept payments from customers. When a payment has been made, PayPal sends us an email with details of the customer's name, email address, amount paid etc.
We would like to do the following;
1. From the PayPal message, extract the transaction date, customer's name, email address, item purchased, item number and amount paid.
2. The details extracted are then pasted into a template to form a receipt cum invoice. The template will have a logo, possibly a "PAID" watermark and certain text required to meet local tax laws.
3. The receipt/invoice is then saved and emailed to the customer.
We would want this all to happen automatically ie upon receipt of the PayPal email.
Would this be possible, and if so, could you please suggest a source for suitable and adaptable scripts? I found this on your site but I think only a small part of it would be suitable;
http://www.slipstick.com/developer/run-a-script-rule-autoreply-using-a-template/
Though I have some experience setting up macros in Excel, I am prepared to give it a go.
We would like to do the following;
1. From the PayPal message, extract the transaction date, customer's name, email address, item purchased, item number and amount paid.
2. The details extracted are then pasted into a template to form a receipt cum invoice. The template will have a logo, possibly a "PAID" watermark and certain text required to meet local tax laws.
3. The receipt/invoice is then saved and emailed to the customer.
We would want this all to happen automatically ie upon receipt of the PayPal email.
Would this be possible, and if so, could you please suggest a source for suitable and adaptable scripts? I found this on your site but I think only a small part of it would be suitable;
http://www.slipstick.com/developer/run-a-script-rule-autoreply-using-a-template/
Though I have some experience setting up macros in Excel, I am prepared to give it a go.