+ Reply to Thread
Results 1 to 10 of 10

create many labels with different pictures

  1. #1
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    create many labels with different pictures

    I would like to be able to create a series of word labels from some data (currently in excel).

    I will have three pictures (a product and a logo and a barcode) and a bunch of text (product details)
    So I want to position everything in exactly the same place and same size on each label (so it looks nice)
    but the pictures will change so it isn't a straight forward same picture on every label scenario.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,695

    Re: create many labels with different pictures

    Provided the images are sized appropriately, all this can be done with little difficult via mailmerge.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: create many labels with different pictures

    I found this video

    https://www.youtube.com/watch?v=R80l8rEa1lQ

    which doesn't look difficult, but it is a bit mysterious.

    I presume this must be the right way to handle it?

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,695

    Re: create many labels with different pictures

    There is some misinformation in that video - especially regarding the assertion you need to use the older 97-2003 .doc format. See the Managing Mailmerge Graphics topic at: https://www.msofficeforums.com/mail-...ps-tricks.html.

    The main issue you're going to have is that the inserted pics will all try to occupy all the available space in each label. There are workarounds for this, such as splitting the cell for each label into multiple rows/columns, giving each of the new cells into which pics will go the appropriate maximum dimensions for the pics to go in those cells. Alternatively, a macro could be used to reformat the images post-merge.

  5. #5
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: create many labels with different pictures

    So this sounds easy enough, but I guess I am still doing something wrong as I can't get the images to show,
    maybe the issue will be immediately obvious to you.

    I am working in office 365 but the purpose is for use with 2013 so if it happened to just be that it would be ok.
    Attached Files Attached Files
    Last edited by scottiex; 11-25-2022 at 04:04 AM.

  6. #6
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,695

    Re: create many labels with different pictures

    Instead of inserting your Image mergefield, all you've done is typed «Image». As stated in the notes at the top of the link:
    the chevrons (i.e. '« »') - are part of the actual mergefields, inserted via the 'Insert Merge Field' dropdown (i.e. you can't type them or copy & paste them from here)
    Last edited by macropod; 11-25-2022 at 09:05 PM.

  7. #7
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: create many labels with different pictures

    Ahh thanks, that was it.

    It works fine now.

  8. #8
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: create many labels with different pictures

    OK so this now works which is good to know.

    but i realize I don't seem to have a particularly accurate control of the label.
    I want to put two images in it (one variable product the other a logo) and then some text between them, and a title at the top.
    But it seems fairly hard to design this using this method.

    I presume another strategy would be to insert images by code... can I write something like this?:

    for each label in document insert image in position x,y (from top left I guess) with width "width".

  9. #9
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,695

    Re: create many labels with different pictures

    You should be able to use nested tables to hold each of the images exactly where you want them position. And, if you specify the exact width and row heights for the nested tables, the inserted images will be constrained to fit within them.

    Once you have the first label configured how you want all of them to appear, pressing 'update labels' should update the rest to the same format. The 'gotcha' with that is that Word will insert the «NextRecord» field inside the first nested table in each cell, not in the cells they're nested in. You should be able to correct that by dragging them to the start of each cell, though.

    See attached demo. I've used the same INCLUDEPICTURE field in both nested tables, but you should get the idea.
    Attached Files Attached Files
    Last edited by macropod; 11-26-2022 at 08:42 AM.

  10. #10
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: create many labels with different pictures

    Thanks,
    This looks pretty good.

+ 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. Inserting Pictures to create Labels
    By AaronBurr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2020, 09:00 PM
  2. Create graph using pictures
    By ygorjesus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2019, 01:23 PM
  3. Create a chart with pictures to show percentages
    By bgriffith005 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-01-2015, 11:34 AM
  4. Create popup window tournament style with pictures
    By JohnnyFeyev in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2012, 06:43 PM
  5. Create email with pictures frame
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2011, 03:02 AM
  6. Replies: 1
    Last Post: 09-11-2009, 08:01 AM
  7. Using Pictures as Data Labels
    By stevepain in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-07-2007, 06:29 AM

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