 |
 | 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 / April 2005Insert Header Row In Table During Merge
Is it possible when merging into a table, during the merge when the LName field first character changes from A to B to C...that a new row could be inserted and formatted so that the output would look similar to the following. -------------------------------------- A -------------------------------------- Adams Arthur -------------------------------------- B -------------------------------------- Brown Boxleitner Or is it something that has to be done manually after the merge is complete?  SignatureRegards Michael Koerner As long as you want the output in tabular format, I think you will need some VBA however you do it, if only to remove empty rows between tables. From previous messages my guess is that that's a turn-off :-) However, if you do not actually need to use table rows, you could do this sort of thing using a catalog/directory merge. But I don't think you could do that, then use Table|Convert text to table, unless you were willing to accept that the rows containing "A", "B" would actually have the same number of columns as the Adams, Arthur rows. Peter Jamieson > Is it possible when merging into a table, during the merge when the LName > field [quoted text clipped - 15 lines] > Or is it something that has to be done manually after the merge is > complete? Peter, thanks. What I do now, after the merge, scroll through the table. When the first character of the last name changes, I insert a row, and insert the upper case character of the names to follow. I don't know VBA so that is out. This was so simple in WordPerfect. you just entered then code in the merge parameters. SignatureRegards Michael Koerner As long as you want the output in tabular format, I think you will need some VBA however you do it, if only to remove empty rows between tables. From previous messages my guess is that that's a turn-off :-) However, if you do not actually need to use table rows, you could do this sort of thing using a catalog/directory merge. But I don't think you could do that, then use Table|Convert text to table, unless you were willing to accept that the rows containing "A", "B" would actually have the same number of columns as the Adams, Arthur rows. Peter Jamieson > Is it possible when merging into a table, during the merge when the LName > field [quoted text clipped - 15 lines] > Or is it something that has to be done manually after the merge is > complete? > This was so simple in WordPerfect. you just entered then code in the merge > parameters. Irritating, isn't it? Quite a lot more things would at least be feasible without VBA if it were possible to use Find/Replace to remove empty paragraphs between table rows, but as far as I know even that requires VBA... Peter Jamieson > Peter, thanks. What I do now, after the merge, scroll through the table. > When [quoted text clipped - 37 lines] >> Or is it something that has to be done manually after the merge is >> complete? Quite irritating at times. Thanks for all the help. SignatureRegards Michael Koerner > This was so simple in WordPerfect. you just entered then code in the merge > parameters. Irritating, isn't it? Quite a lot more things would at least be feasible without VBA if it were possible to use Find/Replace to remove empty paragraphs between table rows, but as far as I know even that requires VBA... Peter Jamieson > Peter, thanks. What I do now, after the merge, scroll through the table. > When [quoted text clipped - 39 lines] >> Or is it something that has to be done manually after the merge is >> complete? |
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.