473,387 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Is it possible to open a new e-mail message in AOL istead of Outlook?

Hello,

At the moment i am using the code below to open up a new email message with all my listed clients e-mail addresses in the bcc field. Unfortunatly instead of outlook i need to open up in AOL.

I'm guessing this may not be possible, as then it would have to open up a browser, login and then create a new message.
So does anyone know of a better way to go about this?


CODE
Private Sub Command12_Click()


Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strEmail As String

Set cn = CurrentProject.Connection
Set rs = New ADODB.Recordset

rs.Open "SELECT * FROM CustomerT WHERE Email Is Not Null", cn

With rs
Do While Not .EOF

strEmail = strEmail & .Fields("Email") & ";"
.MoveNext
Loop
.Close
End With


On Error GoTo Err_Command12_Click

DoCmd.SendObject _
, _
, _
, _
, _
, _
("" & strEmail), _
, _
, _
True

Exit_Command12_Click:
Exit Sub

Err_Command12_Click:
MsgBox Err.Description

Resume Exit_Command12_Click

End Sub



Thanks for your help
Nov 6 '09 #1
2 1505
ADezii
8,834 Expert 8TB
@jammydodger2
AOL is a horse of a different color, but here is some partial code that you can have fun with in you spare time, and it is actually functional. The following code will:
  1. Open America Online/Execute aol.exe
  2. Signs On (with AutoFill User name & Password)
  3. Opens a New Mail Window
  4. Fills in a Recipient (Send to) Name
  5. Fills in a Subject Name
Expand|Select|Wrap|Line Numbers
  1. Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Expand|Select|Wrap|Line Numbers
  1. Dim varRet As Variant
  2.  
  3. 'Launch AOL
  4. varRet = Shell("C:\Program Files\America Online 9.0\aol.exe", vbMaximizedFocus)
  5.  
  6. 'Wait 3 seconds, then Send the ENTER Key (Sign On)
  7. Sleep (3000)
  8. SendKeys "{ENTER}", True
  9.  
  10. 'Wait 10 seconds, then Open a New Mail Window
  11. Sleep (10000)
  12. SendKeys "%M", True     'ALT+M
  13.  
  14. 'Wait 2 seconds, Navigate 1 Down on the Mail Menu (Write Mail, press ENTER
  15. Sleep (2000)
  16. SendKeys "{DOWN 1}", True
  17. SendKeys "{ENTER}", True
  18.  
  19. 'Wait 3 seconds, enter String in the send to Field
  20. Sleep (3000)
  21. SendKeys "FredFlintstone@prehistoric.com"
  22.  
  23. 'Wait 1 second, then hit the TAB Key twice to get to the Subject Field,
  24. 'enter Subject
  25. Sleep (1000)
  26. SendKeys "{TAB 2}", True
  27. SendKeys "<Subject Name Here>"
P.S. - You may have to play with the Delays (Sleep values) in order to make it work on your PC - these Values are in milliseconds)
Nov 6 '09 #2
Thank you for your help
Nov 8 '09 #3

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

Similar topics

3
by: Hans Dembinski | last post by:
Hi there, I run in a problem with a script, that shall work similar like the c-program "most". It should be able to get some text on execution via a pipe but also is interactive by the user via...
2
by: Davis Chord | last post by:
I'm a fairly new Python developer, so I hope that some of my ignorance in this area is understandable. :) I'm developing an application, and I'm uncertain about releasing it as open-source. The...
2
by: Joe Reazor | last post by:
I just upgraded to v1.1 of the framework and VS.Net 2003. I opened up one of my solutions and rebuilt my project and all went well. I then ran my project in debug mode. My program runs up fine,...
9
by: Bryan Ashby | last post by:
All, I'm looking for a way to define a "dummy" variable in JavaScript; specifically for the window object. I would like to define a window object that would normally be generated with...
0
by: Andrew Dowding | last post by:
Hi Everybody, I have been looking at problems with my Windows Forms C# application and it's little Jet 4 (Access) database for the last few days. The Windows Forms app implements a facade and...
2
by: Tomás | last post by:
Up until lately I've been writing all mad kinds of code for accomplishing things, but lately I've decided to lean more toward the whole readability, etc. side of things. I have a command line...
2
by: tejesht | last post by:
Hi All, does anyone know if the following is possible? Is it possible to open a popup from a existing popup? if possible please suggest the code. Thanks in Advance Tejesh
1
by: HopfZ | last post by:
Is it possible to open an external page in background? window.open('http://www.google.com/search?q='+Math.random()); window.focus(); I tried the above code in three browsers: Firefox 2 -...
1
by: LeWaltz | last post by:
hi everyone, i'm here to ask is it possible to include a power point slideshow in vb. i have tried out the function OLE control but i have no idea is it possible or not. i only manage to open the...
9
by: Bill David | last post by:
I know it's very strange to do that since we have the file name when we call: int open(const char *pathname, int oflag,...); And we can store the file name for later usage. But I just wonder if...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.