• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 833
  • 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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