+ Reply to Thread
Results 1 to 2 of 2

Making target stickers for students using spreadsheet data and mail merge

  1. #1
    Registered User
    Join Date
    09-28-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    2

    Making target stickers for students using spreadsheet data and mail merge

    1. I would like to create a word 2007 .doc that consists of labels or a table.
    2. In each label / box I would like to use mail merge to copy data from a excel 2007 spreadsheet and
    3. create a series of labels each with the same headings but different data.
    4. Here is an example of the type of spreadsheets I have been using.
    5. http://www.letsbeinventive.co.uk/wp-...-Drop-Demo.png
    6. Each sticker would have the relevant unique student data after the column heading
    7. I have tried the tutorials on youtube and the web and can use the edit recepients to select from a saved and closed excel file like the example above
    8. But I cannot get the the 'insert merge fields' to show the same headings as the link I have given.
    9. This is the software for excel layout I am using
      http://www.fabian4.co.uk/images/labels/dialog7.gif

    Please can you help?

    THANKS
    Last edited by spavar; 09-28-2014 at 08:30 PM.

  2. #2
    Registered User
    Join Date
    09-28-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    2

    Re: Making target stickers for students using spreadsheet data and mail merge

    Thanks it's solved got it working

    Take your sims spreadsheet and paste by value onto a new worksheet
    Also make sure your top row is the column headers that you want to mail merge and not the usual sims rows of class details at the top
    e.h y11A1 etc

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Why must I keep reconnecting the spreadsheet for my mail merge documents?
    By reallawyer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-21-2014, 03:52 PM
  2. Replies: 1
    Last Post: 07-30-2012, 11:27 AM
  3. Mail Merge or just Merge Spreadsheet Data
    By Mooch in forum Excel General
    Replies: 3
    Last Post: 12-07-2010, 04:56 PM
  4. Inserting Data form a Spreadsheet Into a Mail Merge
    By Tnesper in forum Excel General
    Replies: 4
    Last Post: 08-13-2008, 06:32 PM
  5. [SOLVED] making excel work like a mail merge
    By tjb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2005, 06:15 PM

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