Issue with sending email from Excel

Hello All!

Ive done quite a bit in Excel in the past, but have never set up a process that sends mail, so I'm having difficulties. So I've taken coding from http://spreadsheetpage.com/index.php...il_from_excel/ and http://forums.techguy.org/archive-bu...el-quotes.html
...and it works beautifully in excel.
-----------------

Please Login or Register  to view this content.

---------------------------

Outlook loads, and its then just a case of hitting the send button, and the email just contains info in the subject line.

The workbook that this sits in is pretty much a database containing employee data in up to 10 columns and 150 rows.

I need to send an email to some of the employees in the list, and to do this, the send button would be located on each row, the macro pulling in info from the respective row (namely the email and the data in column L).

The problem is, as the macro is now, I'd need 150 slightly-different copies of the macro, which is silly.

So, what I need is the macro to be amended so that when you hit the button on the row you want, it just creates the email based on the data in that row. The end goal is to just have one macro, but 150 buttons, one on each row.

I hope thats clear....

I would include a copy of the spreadsheet if I knew how to attach files to the post...

Any help that you guys could offer would be very very appreciated!

Adam

---------------
Excel 2007

Please Login or Register  to view this content.

I'd suggest having a look at this page: http://www.rondebruin.nl/sendmail.htm

Details of how to attach a workbook are on the forum rules page.

Dom

Hi Adam

What you're describing is very doable. I'd like to understand the process. For example, you have 150 buttons to send emails and you wish to send an email to 1 or 10 or 100 of those buttons...what's the criteria you use to select the button of the 1 or 10 or 100? Is the criteria different for each individual? Or is it such that I need to send emails to 14 people because Column J says "Gotcha"?

For max freedom for the user and the simpest method to create emails see the attachment.

Hi Adam

This code is in the attached. It's a sample of what you can do with Excel/Outlook. Let me know of issues.

Please Login or Register  to view this content.

Hi Adam
Glad it works for you. If that satisfies your need, please mark your thread as "Solved".

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solved
- Click Save