"You recently created the following Purchase Order which is showing on our reports as being non-compliant as it has not been linked to a contract. HTMLbody = "You recently created the following Purchase Order which is showing on our reports as being non-compliant as it has not been linked to a contract.To enable us to correct this before the end of the reporting period please advise as soon as possible, but not later than Wednesday DDth MONTH, of the correct Contract Number.A list of the current Contracts on AccountNI can be found here.If you have any questions or require further guidance please feel free to give me a call." & vbNewLine & Signature Subject = "Non Compliant Purchase Order" ![]() ![]() It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. Set objOutlookMsg = OutApp.CreateItem(olMailItem) This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. Right now I'm using 'ActiveWorkbook.SendMail' to create and send the mail. Set OutApp = CreateObject("Outlook.Application") Instead of creating an e-mail and sending it, I would like to know the code for creating an e-mail with Draft status. Its basic syntax is as follows: expression.Subject expression is a MailItem object. ![]() ![]() Additionally, it's the default property for Outlook items (including MailItem). because of the number of variable options i think it would be better to have a blank table in email which i can add data to rather than copy from excel sheet. You can use the MailItem.Subject property for purposes of specifying the subject of the email you create with VBA from Excel. However what i need is to create 3 new macros with different text in an email but including a 4x2 table in the middle of the text. I have managed to get to grips with creating an email and adding the text i need including leaving in the default signature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |