View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Name badge Printing last name initial only

If I understand you correctly, you want just the first letter of the last
name to appear on the labels.

If that is correct, you need to set up another column in the datasource in
which you use the Left() function to extract the first letter of the last
name.

Word does not have the ability to make that extraction during the merge
process.

--
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

"sober71989" wrote in message
...
I can get the excel to word to merge but can not seem to get the name
badges
to have the first letter of the last name to merge. I am missing
something !
thamks for any help you can give.