+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    12-23-2014
    Location
    Fort Shafter Hawaii
    MS-Off Ver
    Enterprise
    Posts
    1

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

    I need to enable a macro to allow me to maintain either ".mil@mail.mil" or "@mail.mil" portion of email address and allow users to input different names prior to domain name. Please help.

  2. #2
    Registered User
    Join Date
    12-05-2012
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    31

    Re: Adding email macro in EXCEL to maintain constant email hyperlink but able to change na

    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

    "name@mil.mil"

    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
    Last edited by Excel_Guy02; 12-23-2014 at 08:13 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Email Hyperlink Adding Body/Subject Text
    By jpmorgan123 in forum Excel General
    Replies: 1
    Last Post: 05-12-2013, 12:41 PM
  2. Adding A Hyperlink To Excel Generated Email
    By WJO in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-13-2012, 04:29 PM
  3. Excel Email Macro VBA - How to send an email once all required fields have been fille
    By wallacm2009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 10:51 AM
  4. Adding Names to auto email message
    By Kid_k in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2011, 02:16 AM
  5. Change email address to hyperlink w/Macro
    By dkub in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2011, 12:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1