Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Torn between Kent & Essex, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing labels from XL

    I originally posted this on the Excel board, but now feel I need to cast my net further:

    I have an XL2K sheet with a table. Some of the columns in this table are embedded pictures of chemical structures imported via ISIS for Excel (3rd party app from MDL). I wish to print some of the information (inc structure) in the rows onto an Avery label sheet - ie I don't wish to print every field per record (but they will be the same fields for every record) but I don't want every row printed. Also, the labels need to be printed:

    {~~~~~~} {field1}
    { picture } {field2}
    {~~~~~~} {field3}

    and not

    [ picture ] [field1] [field2] [field3]

    or

    [picture]
    [field1]
    [field2]
    [field3]

    I've tried looking at mailmerge but got totally lost.

    Any bright ideas or tips would be most welcome.

    TIA
    Gavin

  2. #2
    BAM
    Guest

    Re: Printing labels from XL

    Hi Gavster,

    See if this article helps in getting you a starting point:
    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm>http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm</A>

    Also, here is an article that contains the specifics on using Excel as a data source for mail merge:
    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm>http://www.mvps.org/word/FAQs/MailMerge/Cr...ADataSource.htm</A>
    ~~~~~~~~~~~~~
    Cheers!

Posting Permissions

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