| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make outlook visible
After using a bit of code that send an email to outlook I get the email
warning message. Sometimes that message remains in the backround. How do I bring the allready open outlook program to the foreground on my desktop in VBA code? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make outlook visible
olApp.Visible = True
-- HTH RP (remove nothere from the email address if mailing direct) "gopher" wrote in message ups.com... After using a bit of code that send an email to outlook I get the email warning message. Sometimes that message remains in the backround. How do I bring the allready open outlook program to the foreground on my desktop in VBA code? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make outlook visible
it's still not working,...
Dim ol As Object, myItem As Object Set ol = CreateObject("outlook.application") Set myItem = ol.CreateItem(olMailItem) myItem.To = Range("E2").Value myItem.Subject = "A NEW PURCHASE ORDER HAS BEEN CREATED" myItem.Body = "file:" & F & Chr(13) & Chr(13) myItem.Body = myItem.Body & "This message was automatically sent By Master PO 3.0" myItem.Display olApp.Visible = True ' i get an error here. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make outlook visible
That is because you called it ol, so you would use
ol.Visible = True -- HTH RP (remove nothere from the email address if mailing direct) "gopher" wrote in message oups.com... it's still not working,... Dim ol As Object, myItem As Object Set ol = CreateObject("outlook.application") Set myItem = ol.CreateItem(olMailItem) myItem.To = Range("E2").Value myItem.Subject = "A NEW PURCHASE ORDER HAS BEEN CREATED" myItem.Body = "file:" & F & Chr(13) & Chr(13) myItem.Body = myItem.Body & "This message was automatically sent By Master PO 3.0" myItem.Display olApp.Visible = True ' i get an error here. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make outlook visible
Wrong newsgroup: see microsoft.public.outlook
"gopher" a écrit dans le message de news: ... After using a bit of code that send an email to outlook I get the email warning message. Sometimes that message remains in the backround. How do I bring the allready open outlook program to the foreground on my desktop in VBA code? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make outlook visible
Right newsgroup, he is doing it from Excel via automation.
-- HTH RP (remove nothere from the email address if mailing direct) "Phil" wrote in message ... Wrong newsgroup: see microsoft.public.outlook "gopher" a écrit dans le message de news: ... After using a bit of code that send an email to outlook I get the email warning message. Sometimes that message remains in the backround. How do I bring the allready open outlook program to the foreground on my desktop in VBA code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make one column or row always visible? | Excel Discussion (Misc queries) | |||
| Make Object(s) Visible | Excel Discussion (Misc queries) | |||
| Copy and paste visible cells to outlook | Excel Discussion (Misc queries) | |||
| better search: "make worksheet visible" | Excel Discussion (Misc queries) | |||
| Make Command Button visible only in .xlt? | Excel Programming | |||
Hybrid Mode
