I have macro to email sheet3
the macro works perfectly except it shows the name of the workbook followed by today date of the attached workbook
I need this amended so that only sheet3followed by todays date is shown in the attached workbook
Kindly amend this section of my code
your assistance is most appreciated
the macro works perfectly except it shows the name of the workbook followed by today date of the attached workbook
I need this amended so that only sheet3followed by todays date is shown in the attached workbook
Kindly amend this section of my code
Code:
Attachments.Add Destwb.FullName
Code:
With OutMail
.To = Join(Application.Transpose(Range("U1:U5").Value), ";")
.CC = ""
.BCC = ""
.Subject = "Stock Report"
' strBody = "Hi " & Application.Transpose(Range("AA1").Value) & vbNewLine & vbNewLine
strBody = strBody & "Good Day" & vbNewLine & vbNewLine
strBody = strBody & "Attached, please find latest stock Report. " & vbNewLine & vbNewLine
strBody = strBody & "Regards" & vbNewLine & vbNewLine
strBody = strBody & "Mike"
.Body = strBody
.Attachments.Add Destwb.FullName
your assistance is most appreciated
Last edited: