How to open a mail program through code?

[Mota]

Hi;
The available commands (such as DoCmd.SendObject,FollowHyperlink MailTo: )
just open a new message window,and its not enough to connect to internet and
get messages at the time.So i have to open the main window of the Email
program.
How to open user's default mail client(such as outlook,etc) and receive all
emails, thru code,assuming that it is set up to connect to internet and
receives all messages automatically,when it opens.
Thank you in advance.

 

[Rick B]

If the user wants to check emails, they should do so by opeining their mail
program and checking email. What does that have to do with your Access
application?

The functions you mentioned are designed to send data from Access via an
email. checking thier inbox has nothing to do with that process.


Rick B

Hi;
The available commands (such as DoCmd.SendObject,FollowHyperlink MailTo: )
just open a new message window,and its not enough to connect to internet and
get messages at the time.So i have to open the main window of the Email
program.
How to open user's default mail client(such as outlook,etc) and receive all
emails, thru code,assuming that it is set up to connect to internet and
receives all messages automatically,when it opens.
Thank you in advance.

 

[Mota]

What we want to do is to trade text version of tables(our updating files)
thru Email as an attachment,rather than floppy.Now i want to put a command
button(cmdGetFiles) on frmUpdate to open the user's mail client and get that
text files ,before updating process begins.It may be a bit easier than
leading user to quit program and receive emails manually,copy attachments
somewhere,and again back to the program and start updating tables.In
addition,receiving files may be done in the background.What i want is coding
for cmdGetFiles.Supposing that Microsoft Outlook is default email program,it
can be a kind of automation .Can you plz help me?
Anyway,thank you for your attention.

 

[Rick B]

I don't know of a way to do this since it does not fit into the normal scope
of what Access would be doing.

I would bet there is a way. You might search previous posts and see if you
can find anything similar. I have seen posts about "API Calls" which I
think is a way for Access to control other applications. You might see if
that gets you anywhere.

Hopefully one of our well-versed MVPs will have a solution.

Rick B




What we want to do is to trade text version of tables(our updating files)
thru Email as an attachment,rather than floppy.Now i want to put a command
button(cmdGetFiles) on frmUpdate to open the user's mail client and get that
text files ,before updating process begins.It may be a bit easier than
leading user to quit program and receive emails manually,copy attachments
somewhere,and again back to the program and start updating tables.In
addition,receiving files may be done in the background.What i want is coding
for cmdGetFiles.Supposing that Microsoft Outlook is default email program,it
can be a kind of automation .Can you plz help me?
Anyway,thank you for your attention.

 

[Mota]

Ok,Thank you for ur help.

I don't know of a way to do this since it does not fit into the normal scope
of what Access would be doing.

I would bet there is a way. You might search previous posts and see if you
can find anything similar. I have seen posts about "API Calls" which I
think is a way for Access to control other applications. You might see if
that gets you anywhere.

Hopefully one of our well-versed MVPs will have a solution.

Rick B




What we want to do is to trade text version of tables(our updating files)
thru Email as an attachment,rather than floppy.Now i want to put a command
button(cmdGetFiles) on frmUpdate to open the user's mail client and get that
text files ,before updating process begins.It may be a bit easier than
leading user to quit program and receive emails manually,copy attachments
somewhere,and again back to the program and start updating tables.In
addition,receiving files may be done in the background.What i want is coding
for cmdGetFiles.Supposing that Microsoft Outlook is default email program,it
can be a kind of automation .Can you plz help me?
Anyway,thank you for your attention.

 

[Alphonse Giambrone]

I believe you can do what you want through automation.
Try posting in the Outlook newsgroups and check out
http://www.outlookcode.com/d/vb.htm
http://www.slipstick.com/

 

[Mota]

Ok,Thank you.

I believe you can do what you want through automation.
Try posting in the Outlook newsgroups and check out
http://www.outlookcode.com/d/vb.htm
http://www.slipstick.com/