Office Software Thread, Having a Thick Excel Moment in Technical; Hello all,
I have the simple task of mailmerging 246 records onto a template I created in Word. I created ...
21st March 2013, 02:29 PM #1
Having a Thick Excel Moment
I have the simple task of mailmerging 246 records onto a template I created in Word. I created a template with 8 labels per sheet, which would come to 30.75 or just short of 31 pages.
When I select the CSV to merge all records appear correctly, but when actually merging it was only completing 20 odd pages or so. I tried copying the data from the existing CSV into a new CSV, still the same problem. I then copied the CSV into Notepad, then re-copied it into a second new CSV. This time the mailmerge worked correctly completing 31 pages worth.
Setup is Word/Excel 2010 SP1 on Win 7 SP1. I can't quite put my finger on why it only merged 20 odd pages on my first few attempts. A bug possibly? All suggestions welcome
IDG Tech News
21st March 2013, 02:31 PM #2
Did you use a named range? Perhaps that wasn't covering all fields? I think it sometimes defaults to the "Print_area" range, could have been that?
Thanks to LosOjos from:
Michael (21st March 2013)
21st March 2013, 02:51 PM #3
I did think of that, but no it was literally a CSV file. I had the idea to copy/paste to and from Notepad to remove any formatting applied to the cells. Still just a bit of a mystery and another afternoon of head scratching!
By Disease in forum General Chat
Last Post: 8th October 2012, 08:36 PM
By russdev in forum General Chat
Last Post: 6th August 2008, 08:27 PM
By Dos_Box in forum IT News
Last Post: 8th July 2005, 11:49 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)