Visual Basic Help
Managed to get round the problem.
Thanks to your tip, I got the Sender to add their address
into a field in Excel and then copied it into the subject
line.
ActiveWorkbook.SendMail ("Payroll@marks-and-
spencer.com"), ("Debts From Sto ") & Sheets
("Debts").Range("D5").Value
MsgBox "Your details has been sent.",
vbInformation, "Debts"
Application.ActiveWorkbook.Close savechanges:=False
Where D5 is the Senders details.
|