Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
murfitUK
 
Posts: n/a
Default Mail merge - using initial letter of field

I am using an Excel spreadsheet for my mail merge into Word.

How can I get Word to print only the first character of a field? I have had
a look at the switches in the help files but can't find what I'm looking
for.

The data in the spreadsheet is in the format:

Mr John Smith address etc
Mrs Ann Brown address etc

and I would like Word to print the letters:

Mr J Smith
address
etc

Mrs A Brown
address
etc

Is it possible? Thanks for your help.


 
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 Field window should remain open to insert multiple fiel Steinway60 Mailmerge 1 July 20th 05 04:08 PM
Convert to Symbols Omar Menjivar Microsoft Word Help 7 June 27th 05 07:32 PM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
capitalization of the first letter in a mail merge field + excepti karel Mailmerge 1 January 4th 05 10:11 AM


All times are GMT +1. The time now is 08:22 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"