+ Reply to Thread
Results 1 to 2 of 2

Generate several word files using excel data

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    Poland
    MS-Off Ver
    365
    Posts
    1

    Generate several word files using excel data

    Hi,

    I got a little problem

    I got 1 Excel file (with after fill up by user), I will use to generate/change 4 word files (specyfic cells from excel file)

    how can I do it easy way (it is beater to use Acces?)

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Generate several word files using excel data

    Welcome to the forum!

    MailMerge in Word should suffice. You can use Excel or Access as the database.

    'Mail Merge
    ' http://www.excelforum.com/excel-prog...rom-excel.html
    ' http://www.excelforum.com/excel-prog...-document.html
    'Word 's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version). _
    To see how to group records with any mailmerge data source supported by Word, _
    check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
    ' http://lounge.windowssecrets.com/ind...owtopic=731107
    ' or
    ' http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
    ' Kenneth Hobson, Mail Merge from Excel to MSWord: ElephantsRus
    ' https://app.box.com/s/0zlydxinl10t23mifkrr
    ' or, https://www.dropbox.com/s/fx4r06xq4m...sDocs.zip?dl=0
    'Macropod:
    'https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1020168-vba-excel-word-mail-merge-hosted-sharepoint-2.html#post4896255
    'https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1015081-automating-word-mail-merge-excel-2010-vba.html#post4872807
    'https://www.mrexcel.com/forum/general-excel-discussion-other-questions/713478-word-2007-2010-mail-merge-save-individual-pdf-files-2.html#post4796480

+ 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. Generate Multiple Word Documents from Multiple Excel Files
    By TellerFarsight in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2018, 12:58 PM
  2. Generate Word Template and Import Excel Data to It
    By JCDPS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2018, 09:56 AM
  3. [SOLVED] How to Generate a Word document, using VBA, and using part of the data on excel?
    By sylvainsyl20 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-12-2016, 09:58 AM
  4. Generating Word .doc files with data from Excel
    By mbrom in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2015, 02:20 AM
  5. vba script to generate files based on an data from an Excel sheet
    By bananas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2007, 03:00 PM
  6. Generate pdf or word files of a receipt from different suppliers
    By Richard Flame in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2007, 12:50 PM
  7. How to generate ms word doc files from excel sheet.
    By shishi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2005, 01:05 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