User Tools

Site Tools


vsvwiki:mailmerge

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
vsvwiki:mailmerge [2021/06/09 12:34]
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 how to mail merge all the time. Now it'free for everyone to see! -Quinten)+(Mariëtte, you can thank me later. I used to get questions on how to mail merge all the time. Now it'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 ===== ===== Without attachment =====
Line 33: Line 35:
  
 More information can be found in [[https://www.youtube.com/watch?v=yj_s3cdfVDY|this video]]. More information can be found in [[https://www.youtube.com/watch?v=yj_s3cdfVDY|this video]].
 +
 +===== 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 "Labels" under the "Mailings" ribbon.
 +  - 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!
  
vsvwiki/mailmerge.1623234844.txt.gz · Last modified: 2021/06/09 12:34 by bestuah1945