Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    655
    Thanks
    0
    Thanked 2 Times in 1 Post

    Missing Field in Mail Merge (Office 2003)

    If I ever open a Mail Merge document that is associated with a data source file and the document calls for a field that is missing from the data source, I can get into the situation where I can't find any way to cancel out of the merge without stepping through every record even if there are 1200 records. Is there some way to cancel out of that situation?

    If this doesn't make sense I can describe a way to get into this situaiton.

    Thanks,
    Bill

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Field in Mail Merge (Office 2003)

    I always find taskmgr's "End task" option to be a useful form of last resort cancelling <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    A description of a way would be useful.

  4. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Missing Field in Mail Merge (Office 2003)

    There's usually an option to remove the field from the merge document.
    Attached Images Attached Images
    • File Type: png x.png (4.4 KB, 0 views)

  5. #4
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    655
    Thanks
    0
    Thanked 2 Times in 1 Post

    Re: Missing Field in Mail Merge (Office 2003)

    Andrew,

    Yes, you are correct, that is one way to get out of it. I was just hoping there was "nicer" way that I wasn't familiar with. I am pretty sure that I did go past the chance to stop or change the problem in the dialog box that Hans has pointed out when I constructed my sample of how to create the problem so I doubt that there is any reason now to outline my steps.

    Thanks,
    Bill

  6. #5
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    655
    Thanks
    0
    Thanked 2 Times in 1 Post

    Re: Missing Field in Mail Merge (Office 2003)

    Hans,

    Yes, I'm pretty sure I saw and ignored that escape route (dialog box) in my recent simulation of the problem but I seem to hit this problem every now and then and I'm inclined to doubt that I've bypassed that solution every time. In any case, I think I'll just have to wait and see if I can grab the sequence of events the next time I encounter this problem if I haven't ignored that dialog box. It certainly seems that the Cancel button on that dialog box would be a reasonable solution when it does show up.

    I can remember having the very distinct feeling in the past, where I have changed the name of a previously-unused field in the data source and added a reference to the new field to the Word document, and the merge seems to not know about the change to the data file. My recollection is that after encountering this problem I can refresh things in some way and it all works after that. That is all a memory from several months ago but maybe it is the situation where I've encountered this kind of problem. In any case, I'll keep my eyes open for when I have to step through too many records in order to get out successfully and see if there is a scenario where the dialog box does not help.

    Thanks for your help.

    Bill

Posting Permissions

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