Adding email macro in EXCEL to maintain constant email hyperlink but able to change names.

Hello sfskepler,

Using columns A:C

Please Login or Register  to view this content.

Where the result will appear in C2. You would combined (concatenate):
A2 - Input cell for name
B2 - formatted with: '@mil.mil

"[email protected]"

Or without VBA:
A formula In Cell D2


^=A2&B2


If this answers your question, please mark your thread as Solved by selecting Thread Tools ( above your first post) and mark thread as Solved .
Please check the Add Reputation link.

Regards