![]() Attachments.Add "C:\Users\username\Documents\TEST.xlsx" ' to add an attachment, enter the path & name here ![]() 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. You must use VBA to make this work.If you want to set certain Outlook fields when you do a mail merge, you need to use an ItemSend rule. Note – you cannot send recipient-specific attachments in a “normal” mail merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |