This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
vsvwiki:mailmerge [2021/06/09 12:33] bestuah1945 [Mail merge for dummies] |
vsvwiki:mailmerge [2021/06/10 13:25] (current) bestuah1945 |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Mailmerge is a good way to make your mass-mailing seem more personal and appealing. It's not as difficult as you think, and it's a good skill to have. | Mailmerge is a good way to make your mass-mailing seem more personal and appealing. It's not as difficult as you think, and it's a good skill to have. | ||
| - | (Mariëtte, you can thank me later. I used to get questions on this all the time. Now it' | + | (Mariëtte, you can thank me later. I used to get questions on how to mail merge all the time. Now it' |
| + | |||
| + | You need Outlook and Word installed on your computer to do this. It's not possible to mail merge through the webmail. | ||
| ===== Without attachment ===== | ===== Without attachment ===== | ||
| Line 33: | Line 35: | ||
| More information can be found in [[https:// | More information can be found in [[https:// | ||
| + | |||
| + | ===== Printer labels ===== | ||
| + | If you're sending any significant amount of (physical) mail and you don't want to write everything by hand, mail merge is your friend! You can instead print the recipients and their addresses on self-adhesive printer labels, and stick those on your envelopes. This works as follows: | ||
| + | - Open Word. | ||
| + | - Select "Start Mail Merge" and then " | ||
| + | - See if your label type's properties are already available in the list of products. | ||
| + | * If it is, you're lucky: just choose it and you're good to go! | ||
| + | * If it isn't, press "New Label" and put in the label' | ||
| + | - Select the recipient list you want to take your names and addresses from. | ||
| + | - Press "Edit Recipient List" to see if the list is imported as intended. | ||
| + | - Edit the top left label to include all the information and merge fields you want. | ||
| + | - Press " | ||
| + | - With printer labels in particular, it is quite important that you use " | ||
| + | - Put the printer labels in the " | ||
| + | - (Do a test print of only one label sheet to be sure that you're not printing everything on the wrong side of the labels. Trust me, you only make this mistake once. Printer labels are expensive, and save the trees and all that.) | ||
| + | - Print by pressing " | ||
| + | - Print and rejoyce! | ||