+ Reply to Thread
Results 1 to 2 of 2

How can I have Excel cells populate a Word label template?

  1. #1
    MS Questionnairess
    Guest

    How can I have Excel cells populate a Word label template?

    I have an Excel worksheet that I'm using to create a continuous file
    inventory list and a self-created Word .doc for labels (four labels per page).

    Let us say that on the Excel spreadsheet columns A, B and C contain the file
    name components (i.e. A='regional code', B='type code', C='sequential
    number') and row 1 would therefore, say, appear as 'US' 'Report' '1', row 2
    would appear as 'CANADA' 'Letter' '1', etc.

    I have a template label in my Word document that is 4 -labels-per-page. An
    individual label would require the information found on each row under
    columns A, B and C in one area, information from columns 'D' (= 'file subject
    title') and 'E' (=file contents) in another area, etc.

    The first label on the page would have 'US Report 1' in the file name area,
    the second label would have 'CANADA Letter 1' and subsequent labels would
    have information from rows 3, 4, 5, 6, etc.

    I'm not sure how to link the Excel source information, however, to create an
    automatically-generated label from my Word document in an efficient manner
    since the original Excel list will (eventually) contain hundreds of rows and
    is contantly being added to.

    Another problem for me to figure out is how to make sure that each of the
    three subsequent labels on the four-label-per-page template is populated with
    the same kind of column information as the first one and how to automatically
    create a new four-label-a-page page once the first four labels are generated
    so that I'm not constantly trying to remember to print out the labels once
    four are populated.

    Perhaps I'm asking for the world?

    Any tips or direction would be greatly appreciated :-)



  2. #2
    Debra Dalgleish
    Guest

    Re: How can I have Excel cells populate a Word label template?

    I don't know if that's possible, but Word MVP Cindy Meister has merging
    information that may help you:

    http://homepage.swissonline.ch/cindy...r/MergFram.htm

    There's also a Word Mail Merge newsgroup where you could post your
    question, and someone there may be able to help.


    MS Questionnairess wrote:
    > I have an Excel worksheet that I'm using to create a continuous file
    > inventory list and a self-created Word .doc for labels (four labels per page).
    >
    > Let us say that on the Excel spreadsheet columns A, B and C contain the file
    > name components (i.e. A='regional code', B='type code', C='sequential
    > number') and row 1 would therefore, say, appear as 'US' 'Report' '1', row 2
    > would appear as 'CANADA' 'Letter' '1', etc.
    >
    > I have a template label in my Word document that is 4 -labels-per-page. An
    > individual label would require the information found on each row under
    > columns A, B and C in one area, information from columns 'D' (= 'file subject
    > title') and 'E' (=file contents) in another area, etc.
    >
    > The first label on the page would have 'US Report 1' in the file name area,
    > the second label would have 'CANADA Letter 1' and subsequent labels would
    > have information from rows 3, 4, 5, 6, etc.
    >
    > I'm not sure how to link the Excel source information, however, to create an
    > automatically-generated label from my Word document in an efficient manner
    > since the original Excel list will (eventually) contain hundreds of rows and
    > is contantly being added to.
    >
    > Another problem for me to figure out is how to make sure that each of the
    > three subsequent labels on the four-label-per-page template is populated with
    > the same kind of column information as the first one and how to automatically
    > create a new four-label-a-page page once the first four labels are generated
    > so that I'm not constantly trying to remember to print out the labels once
    > four are populated.
    >
    > Perhaps I'm asking for the world?
    >
    > Any tips or direction would be greatly appreciated :-)
    >
    >



    --
    Debra Dalgleish
    Contextures
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05569 seconds
  • Memory Usage 8,853KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (2)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_legacy
  • (2)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1