formula?

A

Alan Bliss

i am using a mail merge and i need to create special email address to be sent
via my online fax service...

the email address go as:

/fax=951-486-3760/[email protected]

I have a fax number and a name in each row in the file i want to insert the
appropriate fax/email address as above
1) how can i get this column to make this formula by pulling from collumn AO
(the fax number?
2) how can i get the name in row AZ to convert into the formula?
3) also the names in column AZ are in this format: Alan Bliss, i need them
to be in this format Alan.Bliss.... how can i exchange the space for a dot?

Please help and Thank you,
I am using all 2003 office products, (by the way)
--Alan
 
B

Bob Phillips

1) =MID(AO2,FIND("=",AO2)+1, FIND("/",AO2,2)-FIND("=",AO2)-1)
2) =MID(AO2,FIND("=",AO2,6)+1,99)
3) =SUBSTITUTE(MID(AO2,FIND("=",AO2,6)+1,99)," ",".")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

B. R.Ramachandran

Hi,

If Column AZ contains names (e.g., AZ2 contains Alan Bliss), and Column AO
contains the fax numbers (e.g., AO2 contains 951-486-3760), and you want to
create the e-mail address in the format you have shown (i.e.,
/fax=951-486-3760/[email protected]) in a new column, use the
following formula in Row 2 of the new column.

="/fax="&AO2&"/name="&SUBSTITUTE(AZ2," ",".")&"@acumenfax.com"

Now you can drag the formula down the new column to create the e-mail
addresses for the names/fax numbers in other rows (e.g., Row 3, 4, ......)

My apologies if I haven't understood your question correctly.

Regards,
B. R. Ramachandran
 
Top