Auto print a prepared text with different names

Hi

I wanted to know if it's possible to auto fill a prepared text and then auto print it with different names

let me explain you with an example:

I have an Excel file with the name of students and their fathers in it

I want to send each one invitations in their name and their fathers' name

e.g. Dear John Smith son of Robert Smith we want you to take part in our celebration .......

So each time I need to copy and paste their name and their fathers' name to the form

Is there a way so that the word or excel do this for me automatically?

Thanks;

Answer
Answer

See the following page of fellow MVP Graham Mayor's website:

http://www.gmayor.com/mail_merge_graphics.htm

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

What you are describing is a mail merge. There's an article at http://office.microsoft.com/en-us/word-help/use-mail-merge-to-create-and-print-letters-and-other-documents-HA101857701.aspx that summarizes the process for Word 2010, and it won't be much different in Word 2013.

When you do this for the first time, you may find it simplest to use the Mail Merge Wizard. So select the Mailings tab. In the Start Mail Merge group, click on Start Mail Merge and choose Step-by-Step Mail Merge Wizard. When you get to Step 3, select "Use an existing list" and browse to the Excel file that contains your data.

Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 23, 2024 Views 7,505 Applies to: