 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2008Name badge Printing last name initial only
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. 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.  SignatureHope 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 >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. 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 > If I understand you correctly, you want just the first letter of the last > name to appear on the labels. [quoted text clipped - 11 lines] > > something ! > > thamks for any help you can give. 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. SignaturePeter Jamieson http://tips.pjmsn.me.uk > Thanks for your help. Yes that I what I want to do I figured out it would > be [quoted text clipped - 19 lines] >> > something ! >> > thamks for any help you can give. |
Reply to this Message |
 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.