Another question, please! Thanks a bunch!

[Damil4real]

I have list of e-mails in sheet2. List of Names in Column A6:A20 & E-
mail addresses in ONLY Column B6.

I want it to be in such a way that when one types in a name in cell
A6:A20, an e-mail is automatically added to Column B6. If another name
is entered in B7, an e-mail is automatically added to the already list
of e-mails in B6...etc. The purpose is to send an e-mail to the list
of addresses in B6, but the list changes every now and then. The e-
mail addresses should automatically end with "@yahoo.com."

Thanks!

 

[JE McGimpsey]

One way:

Put this in B6:

=IF(A6<>"",HYPERLINK("mailto:"&A6&"@yahoo.com",A6&"@yahoo.com"),"")

and copy down.

 

[Damil4real]

One way:

Put this in B6:

  =IF(A6<>"",HYPERLINK("mailto:"&A6&"@yahoo.com",A6&"@yahoo.com"),"")

and copy down.

Man, you are a genius, but sorry I forgot one important info.

The e-mail adresss should be (e-mail address removed). There must be a dot
between the first and last name, and then the @yahoo.com

Thanks!

 

[Damil4real]

Man, you are a genius, but sorry I forgot one important info.

The e-mail adresss should be (e-mail address removed). There must be a dot
between the first and last name, and then the @yahoo.com

Thanks!

Oops, sorry the formula didn't work.

The formula you gave me, when i typed a name in A7, it puts the e-mail
address for that name in B7 instead of adding it to the already e-mail
address in B6. The list of e-mail addresses should only be in B6 with
a semi-colon ( separating them. The macro I have is to only pull the
e-mail addresses from B6.

What I want:

In A6 - John Smith In B6 - (e-mail address removed);
(e-mail address removed); (e-mail address removed); (e-mail address removed)
In A7 - Brian Josh
In A8 - Ja Ja
In A9 - Walsh Adam

I hope you understand.

Thanks for your continued assistance.

 

[muddan madhu]

try this

in cell B6 put this formula
Assumed only first & last name is in your list.

=IF(A6="","",LEFT(A6,FIND(" ",A6)-1)&"."&MID(A6,FIND(" ",A6)+1,255))
&"@yahoo.com" and drag it down

Assumed ( cell C5 is Blank )

In Cell C6 put this formula =IF(B6=B5,B6,C5&","&B6) and drag it down

 

[Damil4real]

try this

in cell B6 put this formula
Assumed only first & last name is in your list.

=IF(A6="","",LEFT(A6,FIND(" ",A6)-1)&"."&MID(A6,FIND(" ",A6)+1,255))
&"@yahoo.com"  and drag it down

Assumed ( cell C5 is Blank )

In Cell C6 put this formula =IF(B6=B5,B6,C5&","&B6) and drag it down









- Show quoted text -

Thanks, again! I tried your formula, but this is what happens (the e-
mail addresses are in B7 & B8):

In A6 - John Smith In B6 - (e-mail address removed);
In A7 - Brian Josh In B7 - (e-mail address removed);
(e-mail address removed);
In A8 - Ja Ja In B8 - In B6 -
(e-mail address removed);[email protected]; (e-mail address removed);

This is what I'm trying to accomplish (Only B6 should have the e-mail
addresses):

In A6 - John Smith In B6 -
(e-mail address removed);[email protected]; (e-mail address removed);
In A7 - Brian Josh
In A8 - Ja Ja

Thanks for your continued assistance!

 

[Damil4real]

try this

in cell B6 put this formula
Assumed only first & last name is in your list.

=IF(A6="","",LEFT(A6,FIND(" ",A6)-1)&"."&MID(A6,FIND(" ",A6)+1,255))
&"@yahoo.com"  and drag it down

Assumed ( cell C5 is Blank )

In Cell C6 put this formula =IF(B6=B5,B6,C5&","&B6) and drag it down









- Show quoted text -

And there is already data in Column C (from C6 downward).

 

[JE McGimpsey]

One way:


=IF(A6<>"",HYPERLINK("mailto:" & SUBSTITUTE(A6," ",".") & "@yahoo.com",
SUBSTITUTE(A6," ",".") & "@yahoo.com"),"")