Macro

  • Thread starter Thread starter saturnin02
  • Start date Start date
S

saturnin02

Hi,
I would like to create a macro that would:
1) open IE
2) Browse to a specified website
3) Enter my user name and password
4) log in
5) go to a specified page in that website and do a search
4) open up a page listed as result of search
5) open up other specified link on page in 4) above
6) find a specified text string on that page
7) copy and paste in custom OL2002 form

I do not know VB so it is a problem.
In Excel, I cd "record" the macro manually.
How do I do it in OL 2002 WIN XP?

Tx,
S
 
See if you can do from #1 to #2 in Excel. Then you might see that what you are asking for does take some VBA sophistication. There is no record a macro in Outlook
 
George,
I tried and couldn't get Excel to "record" it.
BY the way, what is the easiest way to get started in VBA?
I am totally illiterate in VBA.
Tx,
S
See if you can do from #1 to #2 in Excel. Then you might see that what you
are asking for does take some VBA sophistication. There is no record a
macro in Outlook
 
Well what I do is is have a goal in mind. Yours is a good one. Then I go to google and see what might be out there. Usually Visual Basic programs will work just fine. VBA is basically just a procedural language. Try Microsoft. They have many examples on how to use VBA. Don't restrict yourself to just VBA in Outlook. By using Tools | References in the VBA Editor you will see you can add References to a whole slew of other programs in Outlook. I really use very little of Outlook in Outlook VBA. I use mostly DAO and Access. You will use others.
 
Back
Top