 |
 | 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 / November 2005how do i suppress the header record in mailmerge
In Word (MS Office 2003) mailmerge creates a document for the header record which describes what fields are contained in each data record. I only want to create documents for each data record - how do I do this? Create a document with a table. The first row of your table contains your field names. The rest of the rows contain your data. http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm  SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > In Word (MS Office 2003) mailmerge creates a document for the header > record > which describes what fields are contained in each data record. I only want > to > create documents for each data record - how do I do this? I need to do the opposite, this means to keep the header record because my data source is a .txt file without headers. I used to do that with other office versions, but can´t with office 2003. Any help? (I can´t find where to select the header record file.) Thanks. SignatureAdriana "Charles Kenyon" escribió: > Create a document with a table. The first row of your table contains your > field names. The rest of the rows contain your data. [quoted text clipped - 4 lines] > > to > > create documents for each data record - how do I do this? Select Tools > Customize > Commands (tab) Select "All Commands" under Categories (on the left) Scroll down the list on the right to find "MAilMergeHelper" Click and drag it to a toolbar. Close the Dialog. Click on your new button to use the old mail merge. 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 need to do the opposite, this means to keep the header record because my > data source is a .txt file without headers. I used to do that with other [quoted text clipped - 10 lines] >> > to >> > create documents for each data record - how do I do this? Sorry, I´ve already tried this (You 've suggested the same to someone else), but the same assistant appeared. Any other suggestion? Thanks anyway. SignatureAdriana > Select Tools > Customize > Commands (tab) > Select "All Commands" under Categories (on the left) [quoted text clipped - 18 lines] > >> > to > >> > create documents for each data record - how do I do this? If by the same assistant you mean something OTHER than the one with the title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog, then you did not get hold of the right command when using Tools>Customize. If you get the right Mail Merge Helper (the one with the 1, 2 and 3) then under 2 there is a Header Options item under the Get Data pulldown. 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 > Sorry, I´ve already tried this (You 've suggested the same to someone > else), [quoted text clipped - 28 lines] >> >> > to >> >> > create documents for each data record - how do I do this? I have a Spanish version of Word, but no one in the Spanish newsgroup could help me, that's why I'm translating the commands, but the Mail Merge Helper was the only possibility to select (Translating Helper as assistant), but what appears is the same windows as usual, so surely I'm not finding the right option, but couldn't find any other. If I get the 1,2,3 all on one dialog, that would be perfect!! Anyway, I´ll keep trying. Thanks for all your help. SignatureAdriana "Doug Robbins - Word MVP" escribió: > If by the same assistant you mean something OTHER than the one with the > title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog, [quoted text clipped - 35 lines] > >> >> > to > >> >> > create documents for each data record - how do I do this? I've found it, thanks! SignatureAdriana "Doug Robbins - Word MVP" escribió: > If by the same assistant you mean something OTHER than the one with the > title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog, [quoted text clipped - 35 lines] > >> >> > to > >> >> > create documents for each data record - how do I do this? I have a related problem. I also have an Excel data file with no headers. I added the Mail Merge Helper and now have mail/merge set up separate files for data and header but Word is still treating the first record of the Excel data file as the header. Any suggestions? Thanks |
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.