Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| Publish Date not found | ![]() 0 Views |
Create your data source in Excel as shown at the beginning of this video. Row 1 in Excel needs to be your header row.
1. In Word, choose File / New / Blank Document.
2. On the Mailings tab, in the Start Mail Merge group, choose Start Mail Merge / Letters.
3. Choose Select Recipients then Use an Existing List. Locate your saved Excel file.
4. Pick Open and pick the correct worksheet.
Type the date and any other information you want at the top of the letter. Press Enter several times, and insert an Address Block to show the recipient’s name. If the Address Block does not show the correct information (names, address, city, state, and zip) you can use Match Fields from the Insert Address Block dialog box or you can click Insert Merge Field and putting in the address fields.
5. In your document, continue inserting any fields you want in the merge.
6. Preview the letters.
7. Choose Finish & Merge / Edit Individual Documents, make sure All is selected and click OK.
Website with blog post: www.chrismenardtraining.com
And make sure you subscribe to my channel!
— EQUIPMENT USED ———————————
○ My camera – https://amzn.to/3vdgF5E
○ Microphone – https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights – https://amzn.to/3vaxyy5
○ Dual monitor mount stand – https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount – https://amzn.to/3g96FGj
○ Boom Arm – https://amzn.to/3g8cNi6
— SOFTWARE USED ———————————
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Please take the opportunity to connect and share this video with your friends and family if you find it useful.