dexsunsky.blogg.se

If you want to use a different attachment for each person, you'll need to use attachments that are the same name as a message field - the To field will probably be the easiest, although prone to problems. 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.