![]() VotingOptions = "I accept I decline I don't care" Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Recipients may have rules to remove the reminder, flag, and Importance fields. If you use the deferred delivery option, you can use SendAt + 1 to set a reminder for 24 hours after the deferred send time. You can set the reminder to a specific date and time using # 8:00:00 AM# format or use Now + 1 for this time tomorrow (or any number of days in the future). If you are setting a reminder, you'll want change the reminder date and time. What you use in the macro is also what you'll use in the subject field. ![]() Remember: the codeword is case-sensitive. ![]() If you want to change the codeword, choose something unique that you would not expect to use in an email. If the word is found, Outlook removes it from the subject and runs the macro on the messages, adding attachments and setting other fields as needed. To avoid running the macro on all messages you send, I'm using a codeword in the subject. ![]() This macro is not limited to mail merges it checks the subject of every message you send to see if it meets the condition of the If statement. Updated July 26 2017: Changed the macro to use a codeword in the subject and remove the codeword before sending. Double click on ThisOutlookSession and paste the macro in the right pane. To use, open the VBA Editor using Alt+F11 and expand Project1 until you see ThisOutlookSession. Up next, we’ll use mail merge to print the envelopes for the letters.If you want to set certain Outlook fields when you do a mail merge, you need to use an ItemSend rule. To print all the letters, click OK, and OK. This could be useful if we wanted to personalize each letter.īut for this letter, let’s go right to the printer. So let’s enter zero.Įverything looks okay, so go back to the MAILINGS tab and click Finish & Merge.Įven though we chose to create a letter, Word gives us the option to send it as an email, or we could click here and Word would create an individual document file for each recipient. In this document, spacing is added after each paragraph. The address block tool adds paragraph breaks to each line. You can change the formatting of a mail merge field the same as any other text. Select the address block, and go to the PAGE LAYOUT tab. The address itself works fine, but the text would look better without the extra space between the lines. Now if you want to see what the actual letters look like instead of the mail merge field code, click Preview Results. When you are finished setting up the address block, click OK, and the address block field is added to the letter. This last option modifies the address format according to the country or region. Also, our customers are local, so we can choose to Never show the country or region. Next, you can decide whether to Insert the company name.įor this letter, Company Name doesn’t apply. You decide what to include in the address block on the left side, and preview the addresses over here.įirst, let’s choose a less-formal name format to match the greeting. When you are finished, click OK and save your updated list.įinally, let’s add an address block to the top of the letter.Ĭlick ahead of the Greeting Line, press Enter a couple of times, and click the line at the top. To delete an entire recipient, click in the column to the left of the entry, and press Delete, and Yes. Now you can click Edit Recipient List anytime, to view and sort the list.Ĭlick the file name in Data Source, and Edit to add or delete entries, and edit the data. When you have added all the recipients, click OK, and choose where to save the list file, type a name, and click Save. We’ll be using this again when we create envelopes in the next movie. Typing a list can be a lot of work, but keep in mind that you are creating a database that can be used again in other documents and programs, like Microsoft Excel. ![]() When you finish adding information for one recipient, click New Entry to add the next one. Press Tab to move to the next column, or Shift+Tab to move back. In the document body, all we have to do is delete the hyperlinks.Īlso, click Select Recipients and let’s type a new recipient list that has mailing addresses. Click Start Mail Merge and let’s convert the email messages to letters. So now that you have the basics of mail merge, let’s try some different options.įirst of all you don’t have to use the wizard, if you don’t want to.Įverything that you need to do with mail merge is right here on the MAILINGS tab. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |