[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" 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.

[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

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

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

--
Peter Jamieson
http://tips.pjmsn.me.uk

"sober71989" wrote in message
...
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.