asked on

Lotus Notes email

I intend to send an email with an Excel attachment to some users. They will have to open it and fill it in with some infos. Is there a way that to have this email on completion(saved) to be sent to a specific email address.

Cheers

techhealth

You can have a button for the user to click when they complete the form. The code behind the button would be similar to this

Sub button1_click()

    ActiveWorkbook.SendMail _

    Recipients:="admin@company.com", _

    Subject:="Form completed: " & Format(Date, "dd/mmm/yy")

End Sub

Open in new window

Bianchi928

ASKER

Looks simple..but do I have to create the button on each users or can I just have it as a VBScript instead which I can send together with the email.

Please advise
Thanks
Cheers

techhealth

No you actually create the button as part of the Excel file. The code is what gets run after the user clicks the button. This is called VBA (Visual Basic for Applications), which is intended to be embedded in your Microsoft Office files.

Bianchi928

ASKER

As a test I have created an Excel file and have a button in there with your VBA code. But when I click the command button , nothing happens. I will like to remind you that I use Lotus Notes and my default email.

Sjef Bosman

What does this have to do with VBScript?

I mean, why don't you create a Notes form with all the logic it needs and send that to those users?

ASKER CERTIFIED SOLUTION

techhealth

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bianchi928

ASKER

All good