I receive emails with shipping information from suppliers and would like to take some of the information and create a macro that formats the data to send an email to a customer.
So... the email I get from the supplier contains the lines:
Customer Name: John Smith
Shipping Company: UPS
Tracking Number: 353453222
Estimated Arrival Date: 3rd September 2010
When I execute the macro I would like it to create an email to the email address from the line "Email :" above.
Then I would like it to say "Dear" and then the first name from the Customer Name line.
Then I'll add some text and would also like to include all the of information above (Shipping company, tracking number and arrival date)
Thanks so much for your help,