Differences

This shows you the differences between two versions of the page.

--- vsvwiki:mailmerge [2021/06/09 10:29]
bestuah1945
+++ vsvwiki:mailmerge [2021/06/10 13:25] (current)
bestuah1945
@@ Line 1: / Line 1: @@
 ====== Mail merge for dummies ======
 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 how to mail merge all the time. Now it's easy for everyone to find out! -Quinten)
+You need Outlook and Word installed on your computer to do this. It's not possible to mail merge through the webmail.
 ===== Without attachment =====
@@ Line 22: / Line 26: @@
 ===== With attachment =====
-Sending an mail merge with a file attachment is considerably more difficult 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.
+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 {{ :vsvwiki:mergetools_-_2021.zip |this Word extension}}:
+  - (First time only) Install the extension by extracting the .zip file to "C:\Users\<netid>\AppData\Roaming\Microsoft\Word\STARTUP".
+  - 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" and follow the instructions.
+More information can be found in [[https://www.youtube.com/watch?v=yj_s3cdfVDY|this video]].
-Instead, you can follow these steps:
+===== Printer labels =====
-  - Set Outlook to work offline, by selecting "Work Offline" under the "Send / Receive" ribbon.
+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:
-  - "Send" the e-mail like a normal merge, without attachments. The e-mails can now be found in your outbox, but have not been sent yet.
+  - Open Word.
-  - Add the attachment to all e-mails in the outbox by running {{ :vsvwiki:outlook_mail_merge_attachment.zip |this Visual Basic script}}.
+  - Select "Start Mail Merge" and then "Labels" under the "Mailings" ribbon.
-  - When the script is finished, unselect "Work Offline", and the e-mails will be sent.
+  - 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's measurements. These are quite clearly stated on most label packages, often in the same format as they need to be input in Word.
+  - 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 "Update Labels" to copy all information from the top left label to the rest.
+  - With printer labels in particular, it is quite important that you use "Preview Results" to check if all information is displayed correctly.
+  - Put the printer labels in the "alternative" printer tray, and eject all other paper trays to ensure that the printer labels are used for printing. The printer should warn you if you do that, that means you've done it right.
+  - (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 "Finish & Merge".
+  - Print and rejoyce!

VSV Wiki

User Tools

Site Tools

Differences

Page Tools