formula?

[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/name=Alan.Bliss@acumenfax.com

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

[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)


"Alan Bliss" <Alan Bliss@discussions.microsoft.com> wrote in message
news:1A94E30F-7C52-44F6-9FD6-3E2FBF21706F@microsoft.com...
> 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/name=Alan.Bliss@acumenfax.com
>
> 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. 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/name=Alan.Bliss@acumenfax.com) 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




"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:
>
> /fax=951-486-3760/name=Alan.Bliss@acumenfax.com
>
> 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