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