Hi all
I have the below and was wondering how I can reference a cell (i.e. to pick up a name etc) so that the body of the email will read "Dear XXX" instead of just 'Dear". I also need to reference to another cell as well in the body to pull through some additional info. I'll have this code as a hyperlink at the end of each row so that it can use the names from the column list of names.
Assistance would be greatly appreciated.
Please Login or Register to view this content.
Last edited by jeffreybrown; 02-16-2018 at 10:25 PM. Reason: Please use code tags when posting code!
If [H5] is reference cell containing name to be usedPlease Login or Register to view this content.
Last edited by Sintek; 02-17-2018 at 03:02 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Great work, thanks very much
Coolio...Please mark thread as solved...Top of post...Thread tools
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks