If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Getting rid of "separate header" option?
If you are using an Excel spreadsheet as your data source, by default
Word will take the first row of the first sheet as the "header source". If you have to work on a Word document (say, a letter) that previously had a separate header source applied to it, how do you tell Word that you now want to revert back to using the first row of the first sheet as the header source. It keeps trying to look for the previous separate header source file. I've tried just giving it the filename of the spreadsheet as its header source (i.e. the same file as the data source), but it won't have it. Surely there must be a way of "resetting" the option back to not using a separate header source? Thank you for any assistance you can give. I have Googled for this but can find no specific reference to removing it - only putting it on in the first place. Steve |
#3
|
|||
|
|||
Getting rid of "separate header" option?
Changing the mail merge main document type to a normal Word document and
then change it back to the type of mail merge main document that you want to create should remove the header/data source information. You can then attach the new data source. -- 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, originally posted via msnews.microsoft.com wrote in message ... If you are using an Excel spreadsheet as your data source, by default Word will take the first row of the first sheet as the "header source". If you have to work on a Word document (say, a letter) that previously had a separate header source applied to it, how do you tell Word that you now want to revert back to using the first row of the first sheet as the header source. It keeps trying to look for the previous separate header source file. I've tried just giving it the filename of the spreadsheet as its header source (i.e. the same file as the data source), but it won't have it. Surely there must be a way of "resetting" the option back to not using a separate header source? Thank you for any assistance you can give. I have Googled for this but can find no specific reference to removing it - only putting it on in the first place. Steve |
#4
|
|||
|
|||
Getting rid of "separate header" option?
Doug Robbins - Word MVP wrote:
Changing the mail merge main document type to a normal Word document and then change it back to the type of mail merge main document that you want to create should remove the header/data source information. You can then attach the new data source. I tried that, but it did not work. And in answer to the other question, it is Word 2003/Excel 2003 we are using. Steve |
#5
|
|||
|
|||
Getting rid of "separate header" option?
It certainly removes the header source here.
-- 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, originally posted via msnews.microsoft.com wrote in message ... Doug Robbins - Word MVP wrote: Changing the mail merge main document type to a normal Word document and then change it back to the type of mail merge main document that you want to create should remove the header/data source information. You can then attach the new data source. I tried that, but it did not work. And in answer to the other question, it is Word 2003/Excel 2003 we are using. Steve |
#6
|
|||
|
|||
Getting rid of "separate header" option?
I tried the same as Doug, and did various tests all of which showed that
the headersource was removed. So either you are not doing the same as us or maybe there is something different about your document. Peter Jamieson http://tips.pjmsn.me.uk wrote: Doug Robbins - Word MVP wrote: Changing the mail merge main document type to a normal Word document and then change it back to the type of mail merge main document that you want to create should remove the header/data source information. You can then attach the new data source. I tried that, but it did not work. And in answer to the other question, it is Word 2003/Excel 2003 we are using. Steve |
#7
|
|||
|
|||
Getting rid of "separate header" option?
Peter Jamieson wrote:
I tried the same as Doug, and did various tests all of which showed that the headersource was removed. So either you are not doing the same as us or maybe there is something different about your document. Hmm... quite possibly. The department that sent it down to us did say it had been produced from a Word-compatible application (not Word itself). However, we have managed to complete the job by producing another separate header source with the correct fieldnames in, and linking to that! But thanks for the info - I will certainly use that method in future. If we get another "funny" file down and converting it back to a normal Word document does not work, I'll post to this thread again and we'll see what's afoot! Thank you again. Steve |
Thread Tools | |
Display Modes | |
|
|