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:



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

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)


"Alan Bliss" <Alan wrote in message
...
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:



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

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.,
) in a new column, use the
following formula in Row 2 of the new column.

="/fax="&AO2&"/name="&SUBSTITUTE(AZ2," "

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




"Alan Bliss" wrote:

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:



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