Auto print a prepared text with different names

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;

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Answer

Doug Robbins - MVP Office Apps & Services (Word)

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

Suzanne S. Barnhill

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

Contribute to the Microsoft 365 and Office forum!

Word Forum Top Contributors:

Auto print a prepared text with different names

Replies (5)

Question Info

Auto print a prepared text with different names

Replies (5) 

Question Info

Replies (5)