+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    05-13-2009
    Location
    orange county, ca
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Print letter in word with data from excel

    Good afternoon everyone.

    My question is this:

    I have a database with 10,000 names and addresses in an excel doc -excel (03).
    I have a letter i have typed up and need to mail out -word (03).


    Is there a way I can tell word to print the letter 10,000 times, each time changing the name and address at the top using the data from the spreadsheet?

    Any help or suggestions are appreciated.

    Thanks!

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,024

    Re: Print letter in word with data from excel

    in Word: Tools - Letters and Mailings - Mail Merge.

    follow the steps and read the help files on Mail Merge.
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

Thread Information

Users Browsing this Thread

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

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.2.0