+ Reply to Thread
Results 1 to 2 of 2

VBA Code to open word and auto populate labels from excel?

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    44

    VBA Code to open word and auto populate labels from excel?

    Is there a way to write a code to auto open my saved Word template for labels and automatically carry out the mail merge commands to fill in my labels? Is it also possible to put a Command Button on the Word label template which would print my labels?

    I can get my Ecel to open my Word template, but I can't figure out the VBA to automatically get the mail merge to execute all the way up to ready to print?

    I am not great at VBA coding, so would it be easier to run it from the Word template and pull over Ecel, rather than Ecel to Word?

    Thanks

  2. #2
    Registered User
    Join Date
    05-03-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: VBA Code to open word and auto populate labels from excel?

    Using code to solve the problem with document processing is too complicated for me. But I think you can google some manual word processing tools to open word and auto populate labels from excel by customizing the VBA code. Try its free trial first if possible. I hope you success. Good luck.
    Best Regards,
    Arron

+ 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. Replies: 1
    Last Post: 04-26-2012, 06:42 AM
  2. [SOLVED] Code in Excel macro to get all open Word docs?
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2006, 12:10 PM
  3. Replies: 1
    Last Post: 01-13-2006, 07:00 PM
  4. HOW ?Excel chart auto insert /populate a code based on date
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-22-2005, 08:20 AM
  5. [SOLVED] Print labels by using Excel data in a Word mail into word
    By Zoey in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

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