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 / Programming / April 2006

Tip: Looking for answers? Try searching our database.

One letter first names in salutation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dale - 13 Apr 2006 17:55 GMT
All,

I do a lot of mail merges using MS Word.  I've dealt some with field codes
and macros but this situation stumps me.  Is there a way/how would I deal
with one letter first names in a salutation.  For instance, if I'm trying to
use the first name field of an individual from my data but the first and
last name looks like "D Jones" then the resulting salutation would be "Dear
D".  Obviously this is not good.  I would think the answer lies in proper
use of the If-Then-Else style Word Field.  Therein lies my problem.  How to
build an IF statement from looking at my data and deciding whether or not
the data is only one character long.

Can someone suggest how this may be done?  I surmise possibly a Word
"compare" field might do but again, syntax gets in my way.

Help!

Regards
Dale
Jezebel - 14 Apr 2006 01:05 GMT
People's names (at least as they end up in databases) tend to be a pig's
breakfast at the best of times. Usually the best approach to this kind of
problem is to put the list into Excel (Excel can open an Access database);
add a column called salutation; then do whatever's necessary to populate
that column. Eg, use the length() function to find all rows where the first
name is short or missing. Then do your mailmerge from the Excel worksheet.

> All,
>
[quoted text clipped - 15 lines]
> Regards
> Dale
Peter Jamieson - 14 Apr 2006 07:47 GMT
I posted an answer to the duplicate field code question in the mailmerge
fields group.

Peter Jamieson
> All,
>
[quoted text clipped - 15 lines]
> Regards
> Dale
 
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.