Alan Stockenstroom
New Member
- Joined
- Jul 19, 2010
- Messages
- 13
Hi All,
I need help with something. I have been trying to get it to work with hyperlink, but I don't think its exactly right for what I need.
I have information in a spread sheet, and I need to create a reminded email and quote certain cells in the body of the emails.
Basically what I am after is (I have the sheet with all the info in the cells and also the email addresses in cells) I want to run a VBA code that would generate an email link in a cell of the row where the information is help.
In this I need the hyperlink that was created by the VBA code, to basically contact a predefined email body and also quote Cell A1, A2, A3.
In the subject of this email, I must say "text 1" and quote cell A1.
Can anyone help me with this please?
I need help with something. I have been trying to get it to work with hyperlink, but I don't think its exactly right for what I need.
I have information in a spread sheet, and I need to create a reminded email and quote certain cells in the body of the emails.
Basically what I am after is (I have the sheet with all the info in the cells and also the email addresses in cells) I want to run a VBA code that would generate an email link in a cell of the row where the information is help.
In this I need the hyperlink that was created by the VBA code, to basically contact a predefined email body and also quote Cell A1, A2, A3.
In the subject of this email, I must say "text 1" and quote cell A1.
Can anyone help me with this please?