I have two fields in Access, FN and LN that need to be converted to word without being separated by anything except a space. For instance, John in FN and Doe in LN should appear as John Doe, rather than 2 columns. However it goes beyond that. I have about 700 names like that that need to appear that way in word, but between each full name, I need a comma, and then a continued string. In other words, if I have columns like this:
John Doe Jane Doe Chris Doe Amy Doe
They need to end up like this:
John Doe, Jane Doe, Chris Doe, Amy Doe
They need to wrap if the string gets too long because these need to go in a report. Could even possibly be done in Excel and copied to Word, but the end result is this needs to be in a text format.
Any suggestions? Thanks for any help you can give. Please note: I don't know VB so if the solution involves VB I would need very simple step by step instructions.
Also, is there any way to automate this process? I need to create this whole process for an end user so that it automatically does it per her request rather than her having to learn how to use Access, Excel, Word... whatever. I create databases with menus so that end users only have to click a menu item to accomplish whatever task they're needing since they know practically nothing about Access or about programming.