Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by Poet only

Advanced Search

Forums
BYTES
Product Launch
Updates
Developer Toolkit

Today's Posts
Member List
Calendar

Home
Poet

User Profile

Collapse

Profile Sidebar

Collapse

Poet

Last Activity: Dec 10 '13, 09:19 PM

Joined: Oct 17 '13

Location: NC, USA

Subscriptions2
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All Poet only Visitor Messages Only Advanced

Filtered by:

new posts

Poet replied to Can I output data from a query / table / form by email as apposed to attaching?

in Access

Oct 17 '13, 05:38 PM
Assuming you're using Outlook and already have an idea of how to generate the body of the e-mail...

Sure, using Ron de Bruin's Outlook code for Excel and retrofitting it to Access: http://www.rondebruin.nl/win/s1/outlook/bmail4.htm

The basic steps would be:
Include reference to Microsoft Outlook Object Library in the Access VBA IDE.

Augment Ron's Mail_small_Text _Outlook function to include strBody in the function's

...
See more | Go to post

Last edited by Poet; Oct 17 '13, 05:42 PM. Reason: Added mailSend, derived from Ron de Bruin's code.
Leave a comment:
Poet replied to How to connect data base from VB 6.0 to MS excel sheet? Datas should save in excel?

in Visual Basic

Oct 17 '13, 04:38 PM
Create a reference in VB6 to the Microsoft Excel Object Library and the Microsoft Office Object Library.

Using calls to the Excel object model, you can modify Excel as you would in a VBA instance. Great information available here: http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

See more | Go to post
Leave a comment:

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕