Reply
 
Thread Tools Display Modes
  #1   Report Post  
J
 
Posts: n/a
Default How can I edit the format of a mail merge field after it has been.

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
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

--
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
"J" wrote in message
news
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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 02:13 PM
Why does the date format change when I mail merge from Access? Alex Mailmerge 1 December 6th 04 03:25 PM
How merge a field with RTF format 1961JCAP Mailmerge 1 December 1st 04 03:30 PM
Leading spaces in Mail Merge field not printing Cindy M -WordMVP- Mailmerge 0 November 30th 04 06:25 PM


All times are GMT +1. The time now is 01:28 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"