+ Reply to Thread
Results 1 to 3 of 3

Excel/Word Mail Merge, saving as individual documents using two mergefields as name

  1. #1
    Registered User
    Join Date
    12-02-2015
    Location
    Peterborough, England
    MS-Off Ver
    2007
    Posts
    19

    Smile Excel/Word Mail Merge, saving as individual documents using two mergefields as name

    Hi guys,

    This is my first post on the forums, so hoping you can help me!

    Essentially I've constructed a working Mail Merge in which data is pulled from Excel to build a number of different letters. My intention is to arrange a way of saving each letter individually, with two mergefields making up the title:

    I.e, if one Mergefied was 'Customer ref': 1234567 and the second Mergefield was 'Brand': CompanyCo, ideally I'd want individual word docs to be saved with a filename like this: 1234567 CompanyCo

    I've had a scour of the forums and whilst I've found similar queries, how I'm not sure how best to achieve this, nor have I located an instance in which someone has done this with two separate fields, whilst leaving the file editable (i.e. not PDF).

    Can anyone assist? I'm assuming some swish VBA is the answer but I'm a bit of beginner in this respect.


  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,859

    Re: Excel/Word Mail Merge, saving as individual documents using two mergefields as name

    Hi flakjack and congratulations on your first post.

    See the files associated with post #5 in the following thread: http://www.excelforum.com/excel-prog...ail-merge.html

    The above thread:
    a. Uses an Excel Control file that uses VBA.
    b. The control file runs Mail Merge using an Excel Data and a Word document.
    c. This particular control file saves each 'Mail Merged Page' individually.

    The following code excerpt (important lines in red) show how the Mail Merge is accomplished from the Excel control file:
    Please Login or Register  to view this content.
    Lewis

  3. #3
    Registered User
    Join Date
    12-02-2015
    Location
    Peterborough, England
    MS-Off Ver
    2007
    Posts
    19

    Re: Excel/Word Mail Merge, saving as individual documents using two mergefields as name

    Thanks for the response, code worked well, just what I was looking for!

+ 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: 0
    Last Post: 09-11-2015, 09:11 AM
  2. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  3. [SOLVED] Macro for mail merge and save as word documents
    By aganesan99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 09:16 AM
  4. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  5. [SOLVED] How to merge excel and word documents
    By jacqueline in forum Excel General
    Replies: 1
    Last Post: 03-27-2006, 08:52 PM
  6. can I merge documents in excel like I can in Word
    By kaykayIT in forum Excel General
    Replies: 3
    Last Post: 11-09-2005, 10:00 PM
  7. [SOLVED] how do I use mail merge in excel for word documents
    By Lisa J Duffy in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 09:05 AM

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