![]() ![]() If you are doing a letter mail merge, envelopes, lables, or email, Word is the application that handles the mail merge. ![]() I'm focusing on email mail merges in this article but Word is involved in all mail merges. The one field you MUST have that I didn't list was the person's email address. I may need the following fields: title, first name, last name, department, company, job title, and other fields. Your header row or fields must be in row 1 of Excel. I keep my list of individuals in an Excel spreadsheet. If you had 100 people in Excel, after setting up the mail merge in Word, you should end up with 100 Sent items in Outlook's Sent folder. Word - where all Mail Merges happen, including an Email mail merge The order these apps are used would be Excel, then Word, and finally, Outlook.Įxcel - stores the data of individuals you want to send a personalized email ![]() Need to send personalized emails to individuals all at one time? That is called an " Email Mail Merge." I'm going to use Excel, Word, and Outlook - part of Microsoft 365 - to create and send bulk emails out. Other common operations that Excel can be used for include: Graphing or charting data to assist users in identifying data trends. ![]()
0 Comments
Leave a Reply. |