Hi all,



I'm sure this has been asked before but I can't find it on this fine forum!

I am new to using mergefields and I am hoping to do some manipulation on the data within one. I have a field that contains employee names i.e. "Firstname Lastname" and I know that the standard form for company email addresses is "firstname.lastname@companyname.co.uk".

My question is is there a way within mergefield if formulas to automatically format the name field to an email field i.e. replace the space with a "." and add the email url at the end?

Thanks in advance.

Regards

Tom

A mailmerge cannot perform a Find/Replace (i.e. to replace the space with a period); aside from that showstopper, it's quite possible to turn the string into a working email address.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi mate thanks for the info would that be done within VB?

Sure, you can do lots of things with VBA, but then it ceases to be a mailmerge and you have to replicate your entire mailmerge logic etc. in the vba code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Pal,

Did you have a suggestion that wasn't VBA? Purely because I don't want to have to make the documents macro enabled if I don't have to.

Thanks

Tom

Well, you did ask about a VB...

Assuming you can do your merge setup so it outputs:
you could then do a wildcard Find/Replace, where:
Find = (<[A-Za-z0-9]@>) (<[A-Za-z0-9]@>\@[A-Za-z0-9.]{1,})
Replace = \1.\2
to turn all those strings into:
Even so, you wouldn't have clickable email addresses.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yeah apologies for the confusion, thanks for that info. The email address does not need to be clickable just displayed so it looks like that would work!

Thanks

Tom