Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2021, 11:00 AM
Jacob86 Jacob86 is offline How to send a letter with customized name/ID for a large number of people Windows 10 How to send a letter with customized name/ID for a large number of people Office 2019
Novice
How to send a letter with customized name/ID for a large number of people
 
Join Date: Apr 2021
Posts: 2
Jacob86 is on a distinguished road
Exclamation How to send a letter with customized name/ID for a large number of people

Hello



I have a letter that I want to send to almost 2000 people (printed), In this letter, I need to change two things (Name, ID number), the rest of the letter is fixed, I have the data on excel (name, ID number), is there a way to have all letters typed in one file with the name, ID number of each person?

Thanks
Reply With Quote
  #2  
Old 04-27-2021, 11:36 AM
Charles Kenyon Charles Kenyon is offline How to send a letter with customized name/ID for a large number of people Windows 10 How to send a letter with customized name/ID for a large number of people Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 7,363
Charles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud of
Default

This is called Mail Merge.

Use mail merge for bulk email, letters, labels, and envelopes - Office Support
Reply With Quote
  #3  
Old 04-27-2021, 04:21 PM
Jacob86 Jacob86 is offline How to send a letter with customized name/ID for a large number of people Windows 10 How to send a letter with customized name/ID for a large number of people Office 2019
Novice
How to send a letter with customized name/ID for a large number of people
 
Join Date: Apr 2021
Posts: 2
Jacob86 is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post


Thanks, Charles! it's exactly what I'm looking for, appreciated
Reply With Quote
  #4  
Old 04-28-2021, 09:09 AM
Charles Kenyon Charles Kenyon is offline How to send a letter with customized name/ID for a large number of people Windows 10 How to send a letter with customized name/ID for a large number of people Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 7,363
Charles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud of
Default

You are welcome.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to send a letter with customized name/ID for a large number of people print different letter for different people mtwa Mail Merge 2 04-23-2016 09:04 PM
Setting Emails to be send in calendar holidays to group of people Afshin r Outlook 0 11-13-2012 05:19 PM
Send emails to multiple people at once marreco Excel Programming 2 05-13-2012 06:38 PM
How to send a letter with customized name/ID for a large number of people I want to send email to large number of people, with different addressing sanketmlad Outlook 1 10-06-2011 09:32 AM
How to address a letter to 10,000 different people at once. Bit of a Trip Word 0 08-13-2010 08:44 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft