#email

Is it possible to send an email reminder based on a specific date & time via Excel? If it is possible, does Excel have to be open to send or can we set the dates and basically forget about the spreadsheet until it needs to be updated? Below is a checklist where tasks are to be completed before...

Hello All, I'm working on editing this VBA code below to allow edits in additional cells to trigger an email sent to additional email address. Could anyone help me edit this code to allow for this? Private Sub Worksheet_Change(ByVal Target As Range) 'Updated by Extendoffice 2017/9/12 Dim...

Hi, I have a macro for opening a .msg file but I need to also add email addresses. The email addresses will be different depending on the project. Is this possible? The macro I currently have is: Sub OpenOutlookMsg () Dim myoutapp As Object Dim myitem A Object Set myoutapp =...

Hello Guys! I have a code that creates an email. I need to address all the people by name, so I wrote this code: strbodyhi = "< BODY style=font-size:11pt;font-family:Calibri >Hi & Sheets(29).Range(Cells(inter,22).Value" < /BODY >" The result is this: "Hi" &...