+ Reply to Thread
Results 1 to 3 of 3

Mail Merge

  1. #1
    Registered User
    Join Date
    05-12-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Mail Merge

    Hi Folks,

    I hope you can help, as I appear to be fighting a loosing battle!

    I've done a mail merge of letters, and so far, all has gone swimmingly. Unfortunately when it comes to do the labels, I've fallen apart.

    I've created a template to match the labels I'm using (basically a document with a table in it that's 2 cols wide and 7 rows). I then go to mail merge and insert the contact's name and address.

    When I do the merge, it gives me all 14 'boxes' on each page as the same label, rather than giving me labels for 14 different contacts.

    Do you guys know a way around this?

    Yours hopefully!
    Rob
    Last edited by Robbeh; 05-12-2010 at 07:56 AM. Reason: Changing title to solved

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Mail Merge Problem

    Robbeh,

    use the mail merge wizard and select Labels as your document type. The wizard will then lead you through the process and insert a {<NextRecord>} field (or something called quite similar) in the appropriate places.

    Start with your existing label document, delete all merge fields, kick off the wizard and specify that you want to use the current document. Define the first label, and then tell the wizard to copy the first label to the other cells in the table. It will all fall into place nicely.

    cheers
    Last edited by teylyn; 05-12-2010 at 07:41 AM.

  3. #3
    Registered User
    Join Date
    05-12-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Mail Merge Problem

    Splendid - that's it! Thanks so much for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1