Replace characters in mergefield

		Microsoft Office Forums > Microsoft Word > Mail Merge
Replace characters in mergefield

FAQ

Thread Tools

Display Modes

07-17-2018, 12:24 AM

macropod

Windows 7 64bit Replace characters in mergefield

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

Well, you did ask about a VB...

Assuming you can do your merge setup so it outputs:

Code:

firstname lastname@companyname.co.uk

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:

Code:

firstname.lastname@companyname.co.uk

Even so, you wouldn't have clickable email addresses.

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining Characters in Find & Replace	Surge	Word	6	03-10-2020 12:42 AM
Replace All -- inserting a space between two non-consistent characters	knpaddac	Word	1	01-30-2018 12:52 PM
Replace characters in a string	Anthon	Excel Programming	1	11-03-2016 12:48 AM
Use wildcards to replace some characters	mauuuuu5	Excel	2	12-12-2015 07:27 PM
Find and Replace some characters with Bullets	kjxavier	Word	1	01-02-2015 12:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.