+ Reply to Thread
Results 1 to 4 of 4

Spreadsheet to print letters

  1. #1
    Registered User
    Join Date
    04-05-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    56

    Spreadsheet to print letters

    Hi all

    I want to know if it's possible to do this, please let me know and if so is there any tutorials.

    I want to have a spreadsheet where I can enter the Name, address, and account number of 100 customers.

    and the spreadsheet would have a letter template. That template will print a letter for each customer using the data from the spreadsheet.

    Please help as i really need this as I'm printing hundreds of letters and this would save me a lot of time.

    Thank You
    Last edited by fawnlemur; 04-20-2017 at 01:08 AM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Spreadsheet to print letters

    Take a look at Microsoft Word and mail merge.

    https://support.office.com/en-us/art...b-0a948fa3d7d3

    So basically, the Word document is your letter template and the spreadsheet feeds in the names.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    04-05-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    56

    Re: Spreadsheet to print letters

    Wow this is so simple

    Thank You very Much

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Spreadsheet to print letters

    You are very welcome. Happy to here it meets your needs.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Print Word letters using Excel VBA
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 06:01 AM
  2. Need to capitalized letters in spreadsheet
    By phildoc in forum Excel General
    Replies: 3
    Last Post: 12-01-2011, 05:31 PM
  3. Save (print) Seperate Letters to PDF?
    By The Boosh! in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2011, 08:52 AM
  4. Save bulk letters and then print them off all together
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2010, 07:26 AM
  5. print letters and send mails
    By danusko in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2009, 12:01 PM
  6. [SOLVED] How do i print roman letters in the foot note
    By Anwar Al-Harazi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2006, 03:20 PM
  7. [SOLVED] One spreadsheet cell won't print but shows up in print preview?
    By Sally in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 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