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:
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:
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.
Bookmarks