Solved

Send Mail with voting buttons via Access

Posted on 2000-05-11
9
692 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 1

Accepted Solution

by:
Viesturs earned 20 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

695 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