Send custom E-mails from Excel

Hello,

I've been looking in the forum for an answer, but I cannot find one that really suits my very specific needs.

In work in a bookshop, and we take orders from customers. All the customers data are stored within an excel file, that contains the information about the customer and the books ordered. When the book arrives, we click the e-mail hyperlink, and compose a message notifying the reception of the goods.

I would like to have a function that makes this automatically. I've been looking for different options, and the first one I've seen is using "=HYPERLINK" function, but the e-mail I'm trying to compose seems to be too complicated for this to work, as it always end displaying the "#VALUE!" message.

After that I tried using macros, but as I don't know how VB works I can manage to make any of the examples found on the web work for me.

I would need a button in each row, selecting data from that same row, that send the message to the customer.

The message would read something like this:

Dear "CUSTOMER",
the book that you ordered, "BOOK_TITLE", has just arrived. You can come to pick it up whenever it suits you.

Please remember that the book's price is "PRICE" and that you left "DEPOSIT" in deposit.

We hope to see you soon.

Kind regards,

Your Bookshop.

I've attached an excel copy with dummy data so you know how the file is made.test.xls Also, sorry if you do not understand something! I'll be more than glad to explain it somehow if you ask me...

Thanks in advance

Please Login or Register  to view this content.

That should get you pretty close. Just change the sheet names and cell references (and perhaps the verbiage); and you should be good to go.

Hi,

I couldn't test this because one of the following problems:

First:I need this to work with Thunderbird, as it is the program that my company uses... One of the scripts I found actually started the message in Thunderbird, but I couldn't really make it work with my worksheet.
Second: This list is enormous (actually I would need to make it smaller) and it grows a few rows each day. The idea is to make a button/link in each row of a certain column, so when you press that button, it selects the appropiate columns from the same row to send an email. I'm trying to automate this because each delivery we have around 20 customers to send notifications and it is a nightmare to write or copy/paste the same message 20 times.

Thanks!