Hi, I own an online business in which people buy a service that is given to others as a gift.
When people make a purchase, in my shopping cart software I ask them things like the recipient’s name, gender, etc. and I currently copy and paste some of that information into some CRM (Customer Relationship Management) software that I have, which I then use to send a personalized email.
For some other reasons, I have an Excel spreadsheet where I make an ODBC connection to my shopping cart software and each order becomes a row in the spreadsheet.
What I’d like to do is send out the personalized email using the Excel spreadsheet instead. I would basically want to “mail merge” some of the information that I download into the spreadsheet (like the recipient name) to some standard formatted email text thet I have.
Just to be clear, I don’t want to mail-merge the whole spreadsheet, just an individual row at a time as I get new orders.
I’m willing to write some VBA code. Any ideas or places to start? Thanks