Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 770
  • Last Modified:

Send Mail with voting buttons via Access

How do I send Mail including voting buttons with Access
0
TDK031400
Asked:
TDK031400
  • 5
  • 4
1 Solution
 
ViestursCommented:
If you have instaled Outlook 8 or 9
(i don't know about Express) then you can use code, but before , when module is open, select Tools/References and check Microsoft Outlook X.0 Object Library.

Dim olapp As New Outlook.Application
Dim olMail As Outlook.MailItem
Set olMail = olapp.CreateItem(olMailItem)
olMail.Subject = "Important"
olMail.To = "Email@Adress.com"
olMail.Body = "This is text"
olMail.Attachments.Add File_Name
'olMail.Importance = olImportanceHigh

olMail.Display
'olMail.Send

Set olMail = Nothing
Set olapp = Nothing
0
 
TDK031400Author Commented:
Outlook 8
I know how to send the basic email but how would I use voting buttons?
0
 
ViestursCommented:
Then try add lines to code before sending

olMail.VotingOptions = "Text1"
olMail.VotingResponse = "Text2"
 
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
ViestursCommented:
If you wish more buttons then:

olMail.VotingOptions = "Accept;Reject;Abstain"



0
 
TDK031400Author Commented:
Thank you Viesturs, that works.
I have another question:-
Is it possible to insert information from Access(98) into custom fields on a custom form in Outlook(98)?
0
 
ViestursCommented:
Sorry, but i work more with Access than Outlook. I think if you can to create custom form in Outlook then is possible to insert data from Access. But you right, this is another question. :)

Regards
0
 
ViestursCommented:
Why so long delay?
0
 
TDK031400Author Commented:
Comment accepted as answer
0
 
TDK031400Author Commented:
Sorry for delay, I forgot.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now