Name badge Printing last name initial only

[sober71989]

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.

 

[Doug Robbins - Word MVP]

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]

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

 

[Peter Jamieson]

It can in theory be done by using Word VBA to issue a SQL query that
includes a left(fieldname,1) column, but if you're in a position to add the
column you need, it's a lot simpler than the VBA/SQL route.