By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

New e-mail Message - access 2000

P: 2
I am trying to create a command button on a form in MS Access2000 that will take me to a "Create New Message" window in Outlook Express. I have no problem opening the Outlook Express application with a command button but I wan to go the next step automatically.....Lazy????
Not really just inquisitive and besides it would be real handy.
Thanks :eek: :(
Aug 31 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,638
The following code should open Outlook with the New E-Mail Message Window:
Dim strOutlookPath As String, RetVal As Variant

'Create a New E-Mail in Outlook - from Access
strOutlookPath = "C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE /c ipm.note"

RetVal = Shell(strOutlookPath, vbMaximizedFocus)
Aug 31 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.