Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
visual basic | Excel Programming | |||
Visual Basic Help | Excel Programming |