+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,304
    Thank Post
    242
    Thanked 1,589 Times in 1,266 Posts
    Rep Power
    344

    Question Having a Thick Excel Moment

    Hello all,

    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

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,674
    Thank Post
    1,484
    Thanked 1,267 Times in 860 Posts
    Rep Power
    804
    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?

  3. Thanks to LosOjos from:

    Michael (21st March 2013)

  4. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,304
    Thank Post
    242
    Thanked 1,589 Times in 1,266 Posts
    Rep Power
    344
    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!



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 8th October 2012, 08:36 PM
  2. Having a moment how do we do summer moves in embc
    By russdev in forum General Chat
    Replies: 7
    Last Post: 6th August 2008, 08:27 PM
  3. Have I Got Old News For You!
    By Dos_Box in forum IT News
    Replies: 1
    Last Post: 8th July 2005, 11:49 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •