Visual Basic Help

[Duncan Smith]

I have the following in an excel Spreadsheet.

The file is in a shared folder on outlook accessed by
many different users.

What I need is for when the user sends the form via a
macro button, there E Mail Name appears along side the
file, in this case "Debts"

I have tried Ron Bruins Site, but can't find what im
looking for, any ideas.

Cheers
Dunc

ActiveWorkbook.SendMail ("Payroll@marks-and-
spencer.com"), ("Debts")
MsgBox "Your details has been sent.",
vbInformation, "Debts"
Application.ActiveWorkbook.Close savechanges:=False

 

[Frank Kabel]

Hi
you may provide some more details:
- you want to start this email from Excel?
- is the email address of the current author stored in the Excel sheet
- There exactly should this email address appear (as it is already the
sender?)

 

[Duncan Smith]

When the Email is received from the sender, it appears in
outlook with the senders name - in the from field, and
the word debts in the subject field,

I was hoping that the senders email address could also
appear in the subject box as well.

 

[Frank Kabel]

Hi
possib le. But HOW do you currently create/send your email. Directly
from Outlook?

 

[Duncan Smith]

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 Store: ") & Sheets
("Debts").Range("D5").Value
MsgBox "Your details has been sent.",
vbInformation, "Debts"
Application.ActiveWorkbook.Close savechanges:=False

Where D5 is the Senders details.