Hello, I am trying to create a macro (in excel) that generates an email. I have the VBA code for generating the email but I wanted to have a few features in it. Emailing from a macro seems to be very challenging for me and, to be honest, I just recently learned VBA, so I try my hardest to get it right, but it doesn't always come out the way I plan. Here is what I am looking for:
1. I have several Input boxes for the user, one of which asks to enter a name. In the email I wish to have that string (called "String4" below) to appear bold in the message, but not have the whole body appear in bold. (Also, on that topic, is there a way to change the color of certain words in that same email?)
2. I would like the option 'have replies sent to' changed to a different email address.
3. I would like to insert a mailto hyperlink in a sentence in the message, such as "Please contact the Sales Group for question (where "Sales Group" has an embedded hyperlink mailto:[email protected] that the receiver can click on).
Is there a way to do this? I have this as the code (but the outcome is in text format - and I think I need to have it in HTML format). Below is the example of the private sub and I have dim'd strings already in previous subs in the macro (the Strings indicated below are more descriptive in my macro, but I am listing them as String1, String2, etc., so you know where they are).
Sorry for all the questions and I hope this makes sense. Thank you for your time.
Brian
Bookmarks