?
Solved

Send Mail with voting buttons via Access

Posted on 2000-05-11
9
Medium Priority
?
717 Views
Last Modified: 2008-02-01
How do I send Mail including voting buttons with Access
0
Comment
Question by:TDK031400
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 1

Expert Comment

by:Viesturs
ID: 2801052
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
 

Author Comment

by:TDK031400
ID: 2801082
Outlook 8
I know how to send the basic email but how would I use voting buttons?
0
 
LVL 1

Expert Comment

by:Viesturs
ID: 2803734
Then try add lines to code before sending

olMail.VotingOptions = "Text1"
olMail.VotingResponse = "Text2"
 
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 1

Accepted Solution

by:
Viesturs earned 60 total points
ID: 2803787
If you wish more buttons then:

olMail.VotingOptions = "Accept;Reject;Abstain"



0
 

Author Comment

by:TDK031400
ID: 2803820
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
 
LVL 1

Expert Comment

by:Viesturs
ID: 2804721
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
 
LVL 1

Expert Comment

by:Viesturs
ID: 2867617
Why so long delay?
0
 

Author Comment

by:TDK031400
ID: 2867656
Comment accepted as answer
0
 

Author Comment

by:TDK031400
ID: 2867657
Sorry for delay, I forgot.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question