Help with translating mailto: into VB code

[AlienPump]

Hello guys,

Can anyone please help me with this if possible:

For my daily work I have an Excel file and I send out a lot of emails, so I am trying to optimize a little bit.
I already have a "hyperlink" formula set up, but the body of my emails is getting larger and the mailto character limitation is starting to catch up with me, so I was trying to write a VB code instead.

I read some of the posts of Ron de Bruin, but there are a couple of things i cannot figure out:

i have the following mailto command:

Please Login or Register  to view this content.

and just extended it about 1000 times (on 1000 rows) so that it would take relevant data from each row (on each row i have name, ticket number, reference and i made a field with "CONCATENATE" to gather info from the other columns to make out the body)

I tried to write the following code, based on info from Ron's site:

Please Login or Register  to view this content.

my question is how would i have to program this, so that I would have this functionality for each separate row. is it possible to "extend" this code, as I did with the =hyperlink (just dragged it for about 1000 rows and it works with the information from each row, so that each email contains the respected information) or maybe do something with the [D2] ?

Also, what would the .send mechanism be, so that the code can have functionality, similar to the hyperlink - compose the email but not send it as i have to format a couple of things additionally. Is that what the .Display would do?

your help would be greatly appreciated and I hope that you guys can understand what I am trying to accomplish!

Thanks in advance.

[JBeaucaire]

Not using the [D2] syntax. You would have to introduce a loop that you could use a variable for the numeric part of that address, so you will have to switch to the Range() or Cells() syntax.

Please Login or Register  to view this content.

[AlienPump]

@JBeaucaire: Thank you very much this information. I appreciate it very much.

Another question about the new issue, that I am facing now, is how would I introduce the "button" in the sheet itself, so that it would call (execute) this command in the sheet (like the hyperlink I had previously)

Thank you in advance guys.

[JBeaucaire]

To show the Developer tab for Microsoft Office 2010 applications

1. Start the application.
2. Click the File tab.
3. Click Options.
4. In the categories pane, click Customize Ribbon.
5. In the list of main tabs, select Developer.
6. Click OK to close the Options dialog box.