Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / General MS Outlook Questions / March 2008

Tip: Looking for answers? Try searching our database.

Access Automation...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Barnes - 09 Mar 2008 21:25 GMT
What is the Outlook method to add an Access Unbound textbox (used for a
"message") in automation.

I have....
Dim Outl As Outlook.Application, MyMail As Outlook.MailItem, N$
On Error GoTo AAA1
N = "C:\BobDev\Sales" & Format(BegDaily, "mmddyy") & "_" & Format(EndDaily,
"mmddyy") & ".snp"
DoCmd.OutputTo acOutputReport, "DailySummary", _
"Snapshot Format", N, False
Set Outl = CreateObject("Outlook.Application")
Set MyMail = Outl.CreateItem(olMailItem)
MyMail.To = "abc@def.com"
MyMail.Subject = "Sales Summary" & Format(BegDaily, "mm_dd_yy") & "_" &
Format(EndDaily, "mm_dd_yy")
MyMail.Attachments.Add N
'MyMail.Display
SendKeys "^{ENTER}"
Set Outl = Nothing: Set MyMail = Nothing
AAA2:
Screen.MousePointer = 1: Exit Sub
AAA1:
Select Case Err
Case Else
 MsgBox "Error Number " & Err.Number & " " & Err.Description: Resume 'AAA2
End Select

TIA - Bob
Milly Staples [MVP - Outlook] - 09 Mar 2008 21:37 GMT
Try posting this to microsoft.public.outlook.programming_vba for assistance with programming questions.   Few developers hang out here.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.  All
unsolicited mail sent to my personal account will be deleted without
reading.  

After furious head scratching, Bob Barnes asked:

| What is the Outlook method to add an Access Unbound textbox (used for
| a "message") in automation.
[quoted text clipped - 24 lines]
|
| TIA - Bob
Bob Barnes - 09 Mar 2008 21:46 GMT
Will do - thank you - Bob

> Try posting this to microsoft.public.outlook.programming_vba for assistance with programming questions.   Few developers hang out here.
>
[quoted text clipped - 26 lines]
> |
> | TIA - Bob
Bob Barnes - 09 Mar 2008 23:24 GMT
Milly - I'm getting the "Warning Message" about someone trying to access
addresses..is this "Normal" and is there a way to turn that off?

I work w/ a Network guy who would be well-versed in Security.

TIA - Bob

> Try posting this to microsoft.public.outlook.programming_vba for assistance with programming questions.   Few developers hang out here.
>
[quoted text clipped - 26 lines]
> |
> | TIA - Bob

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.