![how to do a mail merge in word for bingo cards how to do a mail merge in word for bingo cards](https://www.avery.ae/sites/avery.ae/files/styles/scale_1_1_ratio_style/public/avery_importer/template/lineart/C6080-10_4004182070611_line.jpg)
Now that all the people that you want to send a card to are added to the X-mas category, you can easily group them together in the following way Removing someone (didn’t receive a card back?) can be done in the same way too by un-ticking the box in front of the X-mas category. Once you’ve added the Category, you can select another contact (or even multiple) and add them to the X-mas Category via the list of categories in the same dialog as above or directly via the dropdown list when pressing the Categorize button. Select a contact-> Edit-> Categories…-> type: X-mas-> press Add to List Select a contact-> Edit-> Categorize-> All Categories…-> New…-> type: X-mas-> press OK Select a Contact-> Categorize-> All Categories…-> New…-> type: X-mas-> press OK
![how to do a mail merge in word for bingo cards how to do a mail merge in word for bingo cards](https://i.pinimg.com/736x/30/82/8d/30828d5c74d8d73fc420119b2d2959e2--word--blank-labels.jpg)
When you have multiple members of a single family in your Contacts folder who all live on the same address, you might want to only add one member to the “X-mas” category for a more convenient Mail Merge (for the next section). This will allow you to easily find and group these Contacts together when you want to send your card. In that case it is useful to tag the contacts that you want to send a Christmas card with a Category called “X-mas” or something similar. You probably don’t send a Christmas card to all your individual contacts. This special Christmas guide helps you prepare by using a special Christmas Category, Mail Merge tips and instructions for cards and envelopes and links to templates and pictures you can use in your design. Scroll through entries & I hope we are sorted.It doesn’t matter if you are sending real Christmas cards or electronic ones, Outlook can be useful to manage either. The DATE field will be showing the date as mm/dd/yyyy REALLY ANNOYINGġ1) Click once on the DATE field (to highlight it)Įnter this text MMM yyyy" so that the field becomes:ġ3) VERY IMPORTANT: Note the lower case dd, UPPERCASE MMM, lower case yyyyġ4) Click preview results until the data shows. I think you are just not following the instructions precisely.ġ) Set up an xlsx file with two headings DATE and DATETEXTĢ) enter the a these 2 dates in the DATE column:ģ) enter this text in the DATETEXT column & don't let it format into a date:Ħ) Click mailings, Start mail merge & letters, Select Recipients & use existing list & select the list you just made & click OKħ) Click Insert merge field & click DATE & then OKĩ) Click Insert merge field & click DATETEXT & then OKġ0) Click Preview Results & jump through the 2 entries. Not sure why Microsoft have made this so complicated. How do you do this Martin? I'm pulling my hair out. The field you selected should now look like this: Step 2: Press Shift+F9 to make the field coding visible. Step 1: select the merge field you want to change.
#HOW TO DO A MAIL MERGE IN WORD FOR BINGO CARDS HOW TO#
This tutorial will show you how to format date, currency and number properly in word during mail merge.įormatting date properly during mail merge in Wordįormatting currency and number properly during mail merge in Wordīefore we change the format of date, number and currency in mail merge, we need to apply following operations firstly. However, when we merge some mails, we should pay more attention to the format of date, currency and number. Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements. How to format date, currency and number during mail merge in Word?