Editor's Blog7 mins ago
Mail Merge from Excel to Word
0 Answers
Having asked a lot of question of late, I have another...
Following on from this:
http://www.theanswerbank.co.uk/Technology/Comp uters/Question608945.html#top
I want to mail merge from excel into word. I have a super great spreadsheet on the go.
When the word doc is set with the merge fields, on pressing 'Merge to new document' it goes mad and make thousands of pages of blank data, even though on the spreadsheet there is no visible data!
Now I understand it is down to me having formulas in the cells (even though this generate no actual figure in the cell as there is no inputted record in the row), thus making the cells 'nonblank cells'.
Problem is this work is not for me and I want to hand the system to people to input records continually over the fortcoming year. Is the only answer REALLY to select 'merge record 1 to 100' when selecting 'merge to a new document' in word if say there are only 100 records at that merging stage?
Following on from this:
http://www.theanswerbank.co.uk/Technology/Comp uters/Question608945.html#top
I want to mail merge from excel into word. I have a super great spreadsheet on the go.
When the word doc is set with the merge fields, on pressing 'Merge to new document' it goes mad and make thousands of pages of blank data, even though on the spreadsheet there is no visible data!
Now I understand it is down to me having formulas in the cells (even though this generate no actual figure in the cell as there is no inputted record in the row), thus making the cells 'nonblank cells'.
Problem is this work is not for me and I want to hand the system to people to input records continually over the fortcoming year. Is the only answer REALLY to select 'merge record 1 to 100' when selecting 'merge to a new document' in word if say there are only 100 records at that merging stage?
Answers
Best Answer
Nobody has yet answered this question. Once some answers have been given, funkylad20 will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There are no answers available for this question.
