Donate SIGN UP

Mail Merge from Excel to Word

Avatar Image
funkylad20 | 22:39 Tue 12th Aug 2008 | Computers
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?
Gravatar

Answers

rss feed

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.

rss feed

Do you know the answer?

Mail Merge from Excel to Word

Answer Question >>