Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Your best bet is to manipulate the data in Excel. If the firstname is in a
separate column, just use a formula that uses the Left() function. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "murfitUK" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Field window should remain open to insert multiple fiel | Mailmerge | |||
Convert to Symbols | Microsoft Word Help | |||
data in mail merge letter being cut off - data source field size? | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
capitalization of the first letter in a mail merge field + excepti | Mailmerge |