vsvwiki:mailmerge
Differences
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/08 17:22] bestuah1945 |
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. | ||
| - | A mail merge can be executed in the following steps: | + | (Mariëtte, you can thank me later. I used to get questions on how to mail merge all the time. Now it's easy for everyone to find out! -Quinten) |
| - | - In Outlook, go to " | + | |
| + | You need Outlook and Word installed on your computer to do this. It's not possible to mail merge through the webmail. | ||
| + | |||
| + | ===== Without attachment ===== | ||
| + | A normal | ||
| + | |||
| + | In Outlook: | ||
| + | - Go to " | ||
| - In options, go to the tab " | - In options, go to the tab " | ||
| - | - Close Outlook | + | - Close Outlook. |
| + | |||
| + | Then, in Word: | ||
| - Under the tab " | - Under the tab " | ||
| - Go to " | - Go to " | ||
| Line 14: | Line 23: | ||
| - That's it! | - That's it! | ||
| - | Always send a test e-mail before you send out the entire batch, to check that the merged fields, addressing, and (in particular) the sending e-mail address are correct. | + | Always send a test e-mail |
| + | |||
| + | ===== With attachment ===== | ||
| + | Sending an mail merge with a file attachment is more involved than a normal mail merge. If at all possible, try to avoid this. Most of the time, the type of mail involving an attachment need not be personal at all, as it's often something like meeting minutes that is clearly addressed to a larger audience; no need to be personal there. | ||
| + | |||
| + | Instead, you can use {{ : | ||
| + | - (First time only) Install the extension by extracting the .zip file to " | ||
| + | - Ensure you have the same Outlook settings as required for a normal mail merge, to ensure that your e-mails are sent from the correct account. | ||
| + | - In Word, you should now have a new ribbon, "Merge Tools" | ||
| + | - Select "Merge with Attachments" | ||
| + | |||
| + | 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! | ||
vsvwiki/mailmerge.1623165768.txt.gz · Last modified: 2021/06/08 17:22 by bestuah1945
