Hi all
Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()
Dim Recip()
With ActiveWorkbook
ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="example@example.com"]example@example.com[/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="redundancy@marks-and-spencer.com"]example[/EMAIL][EMAIL="2@example.com"]2@example.com[/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With
End Sub