View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sober71989 sober71989 is offline
external usenet poster
 
Posts: 2
Default Name badge Printing last name initial only

Thanks for your help. Yes that I what I want to do I figured out it would be
easier to just add a column to excel and do it that way. I was just thinking
there was another way but I guess if it gets done it is the right way.
Thanks so much for your help. Melissa

"Doug Robbins - Word MVP" wrote:

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.