Mail to Excel data merge/macro?

Joined
Apr 22, 2005
Messages
103
Reaction score
0
Points
16
Hi guys,

I receive email requests from customers (via apple mail app), generated from a form on my website. The info is, name/address/phone number/what design they would like.

I then type the info manually into excel. Is there a way or a macro that could do this automatically for me?

Many thanks!
 
Joined
Jan 4, 2006
Messages
1,385
Reaction score
146
Points
63
Location
Hamburg, Germany
Your Mac's Specs
MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
Instead of sending it as an e-mail you can design it to write to a mysql database. Once a database is setup and running, you can do all different types of queries at your will.

Perhaps it is possible to create an Apple Script to read it from the Mail Box but I have never tried it.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top