+ Reply to Thread
Results 1 to 4 of 4

Macro to save mail merged word docs to users desktop and with a desired file name

  1. #1
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Macro to save mail merged word docs to users desktop and with a desired file name

    Hi Team,

    As we are aware, when we perform a mail merge and preview the letters, the multiple records get printed into a single document.

    I have the below macro that saves each individual record separately on my desktop in a Mail Merged Folder.

    Please Login or Register  to view this content.
    My Concern - The macro would now be used on many users desktop and as you can see I have my desktop path in the macro that would affect the macro if used on other users desktop.

    What I need -

    1. I want the macro to automatically create a folder on the users desktop as "Merged Docs" and direct the macro to save all the docs in that path.
    2. The macro currently saves each document as "Merged1", "Merged2", "Merged3"........... I would like the file name to be saved as per column A (Employee Number) on my excel list used for mail merge.. So that the word docs are saved as "1000000", "10000002", "10000003"......

    Thanks in advance.
    Thanks,

    Bonny Tycoon


  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Macro to save mail merged word docs to users desktop and with a desired file name

    Hi Every1,

    I was able to solve my 2nd requirement. Can any1 help me with a macro code for word that would create a folder on any user desktop (so that the code would not have any reference to my desktop and instead be a universal code that can be used on any users desktop)

  3. #3
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Macro to save mail merged word docs to users desktop and with a desired file name

    I dont think I wud get an answer. Would close the thread in sumtime..

  4. #4
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Macro to save mail merged word docs to users desktop and with a desired file name

    Closingggg

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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