Thanks for taking the time to read our post.
We spend a lot of time receiving customer orders from online retailers and copy and pasting that data into excel. We would like to automate as much of this as possible. Below is a sample of the email we get:
From: firstname.lastname@example.org (always from the same email address)
Subject: Dropship order-DeysUS Inc (always the same email subject)
Email Body (format is always the same):
I am writing to place a drop ship order for DeysUS Inc, mentioned below are
shipping and billing details:
Product Name: Life is Like A Camera
Color: 9x12 (23cm x 31cm) Solid
Item #: 0004-7512
68239 WINGATE DR
WASHINGTON, MI 48095-1253
20379 W Country Club Dr, Ph 31
Aventura, FL 33180
Please feel free to contact us if you have any further questions.
We want the script to record the date the email was received (8/13/2016) pull in the item # (0004-7512), item name (Life is Like A Camera), color (9x12 (23cm x 31cm) Solid), quantity (1) and shipping address of Ship To (Polly Wilson), Address (68239 WINGATE DR), City (WASHINGTON), State (MI), Zip (48095-1253), PH (5866516233) and put it into an excel document just like the one attached to this listing.
The script would also need to create an order number using the below formula:
Order Number = "deysus" & Date (81316) & "-" & a number representing the order the email was received (first email = 1, second email = 2, etc.) = order number for the above would be deysus81316-1
After the information is copied to excel reply back to the email with the text: "Your order number is" & ordernumber
Once this has been completed we want the script to move the email to a folder called "deysus done"
That is it. Thanks again and let us know if you have any questions. Thanks.