Continue to add field names to this text box by double clicking on each. Notice that the field names are the same as each cell in the first row of our spread sheet.īy simply double clicking on one of the field names, Microsoft Publisher® creates a text box for you and inserts the field name into it. Now your wizard should be displaying the field names you have available from your list. Pretty simple, huh? After selecting a list option, click the “Next” option at the bottom of the wizard. Here’s what out example list looks like in Excel: The first step is to choose whether you have a list to merge already or if you want to make a new one (or if you want to use your Outlook contacts).įor this example we already have a list to merge. This wizard will help guide you through your Mail Merge. In the Main Menu at the top of the window, go to: Tools > Mailings and Catalogs > Mail MergeĪ Mail Merge wizard will appear on the left side of your window (unless you have moved your wizard window to another place). In order to keep the focus on Mail Merging for this post, we’re going to skip the whole design step and move right on to creating the Mail Merge. Open the template in Microsoft Publisher® (some may have opened automatically).īefore starting the Mail Merge, in this step you would also create your postcard design. Step 2: Open Template In Microsoft Publisher®
#MAIL MERGE FROM EXCEL TO PUBLISHER DOWNLOAD#
Use the green Download button on the right of the page to start the download. Step 1: Download The Four-of-a-Kind Postcard Templateįirst we’ll need to download the Four-of-a-Kind Blank Postcard Template. Edward Awesomesauce Appointment Reminder Card How To.Ĭlick on each image below to enlarge it in a new tab or window. If you’ve been with the blog for a while you may recognize some of these names from the Dr. With the Four-of-a-Kind template, we’re already set up to print four postcards onto one sheet! We’ll be using the Four-of-a-Kind template, but these steps will work for any kind of mail merge. It is also created with the purpose of printing one thing to multiple times on the same sheet of paper.įor this post we’re going to be printing addresses onto postcards. Microsoft Publisher® was created to, well, Publish. It is generally easier to do a Mail Merge in Microsoft Publisher® than trying to use Microsoft Word® to mail merge.
0 kommentar(er)
