Sending Emails VBA - Specify Who From

Hello

I have a spreadsheet where it looks up the email address of someone based on the name and then sends an email to that person. A lot of people will be using this spreadsheet but we want it to look like it comes from the same person each time

My code is

Please Login or Register  to view this content.

Is there a way to specify the address it is sent from? I've tried:

Please Login or Register  to view this content.

But this doesn't work. is there a command to do this?