How do I automatically input emails if I know the protocol?

Hi Everyone,

I have a sheet with First Name, MI, and Last Name in Columns A, B, and
C and company domain in column D. I would like figure out how to
combine these into an email address in column E that reads
FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
[email protected]. Ideally I would like to maybe make macros for
common email protocols as well. Any Ideas?

Regards,

Reece

=LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2)

if you want it to start up the email program when you select the cell

=HYPERLINK("mailto:"&LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2),LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2))



for the second question

http://www.rondebruin.nl/sendmail.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


<[email protected]> wrote in message
news:[email protected]...
> Hi Everyone,
>
> I have a sheet with First Name, MI, and Last Name in Columns A, B, and
> C and company domain in column D. I would like figure out how to
> combine these into an email address in column E that reads
> FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
> [email protected]. Ideally I would like to maybe make macros for
> common email protocols as well. Any Ideas?
>
> Regards,
>
> Reece
>

E1 formula

=left(A1,1) & C1 &"@" & D1

"[email protected]" wrote:

> Hi Everyone,
>
> I have a sheet with First Name, MI, and Last Name in Columns A, B, and
> C and company domain in column D. I would like figure out how to
> combine these into an email address in column E that reads
> FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
> [email protected]. Ideally I would like to maybe make macros for
> common email protocols as well. Any Ideas?
>
> Regards,
>
> Reece
>
>

Thank you very much Peo.

Peo Sjoblom wrote:
> =LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2)
>
> if you want it to start up the email program when you select the cell
>
> =HYPERLINK("mailto:"&LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2),LOWER(LEFT(A2))&LOWER(C2)&"@"&LOWER(D2))
>
>
>
> for the second question
>
> http://www.rondebruin.nl/sendmail.htm
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> > Hi Everyone,
> >
> > I have a sheet with First Name, MI, and Last Name in Columns A, B, and
> > C and company domain in column D. I would like figure out how to
> > combine these into an email address in column E that reads
> > FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
> > [email protected]. Ideally I would like to maybe make macros for
> > common email protocols as well. Any Ideas?
> >
> > Regards,
> >
> > Reece
> >

If you wanted to be able to click on the e-mail address and have it open a
new mail message then just add the hyperlink to my formula

=hyperlink(left(A1,1) & C1 &"@" & D1)

"RJ" wrote:

> E1 formula
>
> =left(A1,1) & C1 &"@" & D1
>
> "[email protected]" wrote:
>
> > Hi Everyone,
> >
> > I have a sheet with First Name, MI, and Last Name in Columns A, B, and
> > C and company domain in column D. I would like figure out how to
> > combine these into an email address in column E that reads
> > FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
> > [email protected]. Ideally I would like to maybe make macros for
> > common email protocols as well. Any Ideas?
> >
> > Regards,
> >
> > Reece
> >
> >

Not really, you need to use mailto if you want to use it as an email
address, else it will return an error

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"RJ" <[email protected]> wrote in message
news:[email protected]...
> If you wanted to be able to click on the e-mail address and have it open a
> new mail message then just add the hyperlink to my formula
>
> =hyperlink(left(A1,1) & C1 &"@" & D1)
>
> "RJ" wrote:
>
>> E1 formula
>>
>> =left(A1,1) & C1 &"@" & D1
>>
>> "[email protected]" wrote:
>>
>> > Hi Everyone,
>> >
>> > I have a sheet with First Name, MI, and Last Name in Columns A, B, and
>> > C and company domain in column D. I would like figure out how to
>> > combine these into an email address in column E that reads
>> > FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
>> > [email protected]. Ideally I would like to maybe make macros for
>> > common email protocols as well. Any Ideas?
>> >
>> > Regards,
>> >
>> > Reece
>> >
>> >