Transfer particular pieces of data from Excel into Word over a large number of documents

Tags:
Excel 2007
Microsoft Excel
Microsoft Word
Word 2007
Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone's name and address in Microsoft Excel 2007, and would like to be able to quickly print out a letter containing this data in Word to everyone on the list. Is there a way I can do this without using copy/paste for each piece of data on the spreadsheet, thousands of times, for each letter? I appreciate any help you could give me! - Michael

Software/Hardware used:
Microsoft Word 2007, Microsoft Excel 2007
ASKED: March 4, 2010  7:12 PM
UPDATED: March 5, 2010  4:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Look at using the Mail Merge functionality. Check the Word help for details

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KasMcc
    We do this all the time. You start a mail merge in Word and tell it to use an existing list. In the selection box, pick your excel sheet It is important that your excel sheet has a header row on line 1, as the mail merge uses this as the field names for the merge K
    230 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following