Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2004

Tip: Looking for answers? Try searching our database.

How can I edit the format of a mail merge field after it has been.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J - 08 Dec 2004 14:05 GMT
I have a project where the datasource for a mailmerge cannot be modified.  
The customer can enter a complete middlename but on the merge document they
only want to see the first letter and a period.  (Enter Lee but want to see
L.)  When merge is clicked a new document is created.

How can I modify a mergefield after the merge has occured?

Thanks-J
Doug Robbins - 09 Dec 2004 00:46 GMT
Manually.

However, if there's a lot to be done, execute the merge to a catalog (or in
Word XP and later) directory type mailmerge where you have a one row table
in the main document with each mergefield in a cell of that table.  Execute
that merge to a new documnet, then select the table that is created and copy
and paste it into Excel, and then use a formula in Excel to get the first
character of the middlename and add a period to it and then copy that
formula down for each row in the data source.  Add some field names as the
first row in that spreadsheet and then use it as the data source

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a project where the datasource for a mailmerge cannot be modified.
> The customer can enter a complete middlename but on the merge document
[quoted text clipped - 6 lines]
>
> Thanks-J
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.