Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Excel to Word, Mail Merge Macro to Automate

  1. #1
    Join Date
    17th June 2011
    Posts
    238

    Excel to Word, Mail Merge Macro to Automate

    Hello all,

    I am trying to macro the use of an Excel list and Mail Merge through Word. I am wondering if you can set a macro to the entire Mail Merge process through Excel.

    For example, the code below is what I currently have to save and close Excel and open the Word document. I want to take that a step further and point the merge at Sheet2 of the Excel document, start the merge process, then close Word.

    Is this possible?

    Thank you so much!


    VB:
    Sub Open_Word_Document() 
         'Opens a Word Document from Excel
        Dim objWord As Object 
        Set objWord = CreateObject("Word.Application") 
        objWord.Visible = True 
         'Change the directory path and file name to the location
         'of your document
        objWord.Documents.Open "File path here" 
        ActiveWorkbook.Save 
        Application.Quit 
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    17th June 2011
    Posts
    238

    Re: Excel to Word, Mail Merge Macro to Automate

    Bump.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 3
    Last Post: May 4th, 2011, 19:48
  2. Word/Excel mail merge using DDE + macro(s)
    By Dave Hawley in forum Office 2007 Migration and Application Compatibility
    Replies: 0
    Last Post: April 7th, 2010, 21:31
  3. Macro To Mail Merge Into Word?
    By carlosbourn in forum Excel and/or Word Help
    Replies: 1
    Last Post: April 15th, 2008, 22:41
  4. Mail Merge to Word Macro
    By badgerade in forum EXCEL HELP
    Replies: 1
    Last Post: February 23rd, 2006, 21:58
  5. Mail merge from Excel to Word - Crashes Word on closing let
    By SleeplessInSomerset in forum Excel and/or Word Help
    Replies: 2
    Last Post: April 28th, 2004, 00:07

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
  •  
porno