Cia terminal login screen. I'm the question owner. Expired drivers license army counseling magic bullet.
I currently work with a VBA that is set up to gather data then create and send an email in outlook but is wondering how could I alter the email output i.e. Bold text, change font, color and size, underline, etc. I have copied the email text in code below: Msg = Recipient & vbCrLf & vbCrLf Msg = Msg & 'Below you will find your Alert Type and Count for the week. ' & 'These alerts need to be resolved by 5pm CST on Friday ' & 'to receive 100% Alert Resolution for the week.' & vbCrLf & vbCrLf Msg = Msg & 'Your alerts for ' & Dept & ' are:' & vbCrLf & vbCrLf & AC1 & AT1 & vbCrLf & AC2 & AT2 & vbCrLf & AC3 & AT3 & vbCrLf & AC4 & AT4 & vbCrLf & AC5 & AT5 & vbCrLf & AC6 & AT6 & vbCrLf Msg = Msg & 'Please let me know if you have any questions.' & vbCrLf & vbCrLf Msg = Msg & 'Thanks and have a great week!'
![]() See More On Stackoverflow![]() Give More Feedback
Making crack with levamisole for fish. & vbCrLf Msg = Msg & SW 'Create Mail Item and Send it Set Mitem = OutlookApp.CreateItem(0) With Mitem.to = Emailaddr.Subject = Subj.attachments.Add Attachmentt.Body = Msg.Send End With End If Next End Sub.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |