Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Setting email priority in access97 vba code

Posted on 2000-04-13
3
Medium Priority
?
286 Views
Last Modified: 2012-05-04
I have this piece of code I use in Access97 which sends an email to Groupwise5.5 and it works just fine. What I would like to do is add a priority to the mail being sent but I do not know what the line of code is. I have tried
oMessage.Priority.High and oMessage.Priority = High
nether works. Also, what is the line of code for putting a mail address in the CC box?

Set oApp = CreateObject("NovellGroupWareSession")
Set oAcct = oApp.login("", "")
Set oMessages = oAcct.Mailbox.Messages
'create new message
Set oMessage = oMessages.Add()
'get mail address
oMessage.Recipients.Add ToYou
oMessage.Recipients.Add ToCC
'get subject for message
oMessage.Subject = Subj
'get message text
oMessage.BodyText = Mess
'get attachement if any
oMessage.attachments.Add AttchFile
'send it out
oMessage.Send

thanks for any help
bobh




0
Comment
Question by:bhynes
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Believer earned 150 total points
ID: 2714485
Unfortunately, when you use the following method to set object references:
   Set oApp = CreateObject("NovellGroupWareSession")
you don't get intelli-sense or object model.
Have you tried, therefore, setting a reference (tools... references) to the GroupWise object model so you can use intelli-sense or, better yet, review the object model (view...object browser or simply F2)?
0
 

Author Comment

by:bhynes
ID: 2717986
The answer was the long way around and took me a long time to figure out when all I needed was oMessage.Priority = 3. Even so, thanks for the help it did get me to an answer.
0
 
LVL 7

Expert Comment

by:Believer
ID: 2723030
You're welcome, but sorry it turned out to be the long way around :(
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

877 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