Adding Suffix to a cell value

Dear All

Please find the test.xls file attched

I would like to be able to look at cell C2's value and populate this in cell E2 by adding 'ValueofC2@gmail.com' . I am sorry this may be a very elementary question, but do not seem to understand how i can do this. I will really appreciate your assistance.

Use this in E2 and copy down as necessary:

=C2&"@gmail.com"

Hi Stephen, thank you ... 1 more query before I mark this query as solved.

I will have a list 500 or so clients in E2 whom I am trying to send bulk email to - as a result my idea was to export the list in Cell E to outlook via text file (emails separated via semicolons) or if there is a better method - please will you kindly be able to guide on this?

You should be able to copy your list from Excel and paste into the To box in Outlook.