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