xoutapp

Hi, Looking to have a button within a spreadsheet that creates an email using outlook. Rather than just saying "Hello", I'd like it to say good morning up until 12:00, good afternoon until 17:00 and good evening. I'd also like to insert a signature at the bottom. Here's what I have so far...

Hi All, i'm wanting to create an auto email to be sent from excel when a cell in I equals more than one, kind of like an alert... However i would like this email to include certain cells of information depending on which cell in I has changed. For example if I10 changes i would like cells A10 to...

Good Afternoon, i am currently running this code Sub Macro1() Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Hi there" & vbNewLine & vbNewLine & _...

Good afternoon everyone, I got some code that will automatically send an email based upon cell value. I got the To and CC fields right, but I cannot get the From field to send from the right mailbox/distro. Anyone know how I can do this? Private Sub Worksheet_Change(ByVal Target As Range)...

Hi, i hope you can help again beginner at this and still learning :), i havethe code below which i have put in for command button, so when clicked it copiein the cells from a - k and only data that hasi want to do this multiple times heading above the code, but the below isnt helping any chanyou...