[AccessD] Access Data into Outlook

Thanks Andy, 
 
I'm off to vacation and will try it when I get back next week. Thanks again.

Andy Lacey <andy at minstersystems.co.uk> wrote:
Hi again Lonnie
I didn't give you the code to clear down a folder. If you need it it goes
like this:

Do While objOutlookFolder.Items.Count > 0
objOutlookFolder.Items(1).Delete
Loop

You're always deleting the first item over and over. It does work. You fit
that in after you Set the folder in previous example.

--
Andy Lacey
http://www.minstersystems.co.uk


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Lonnie Johnson
> Sent: 12 May 2005 21:58
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Access Data into Outlook
>
>
> Sure thing. I actually have a table with employee information
> but it is in SQL Server. I didn't see anything in Outlook
> help that said anything about SQL Server. So I thought I
> would have an Access database with a link to the table and go
> from there. I want to create a contact list in a public
> folder in Outlook. It will be like a Company Directory.
>
> I knew it could be done. Thanks Andy, I'll be looking for your reply.
>
> Andy Lacey wrote:
> Hi Lonnie
> Yes it is but what are you trying to do? You can use the
> Outlook object model to link programmatically. Describe what
> you're after doing and we may be able to make suggestions.
>
> -- Andy Lacey
> http://www.minstersystems.co.uk
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > Lonnie Johnson
> > Sent: 12 May 2005 14:07
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Access Data into Outlook
> >
> >
> > My subject line was wrong it said Access Data into SQL Server
> > instead of Outlook.
> >
> > Lonnie Johnson
> wrote:Is it possible to
> > programatically link, transfer or copy information from an
> > access table (employee information) into a global or public
> > folder in Outlook?
> >
> > It's gotta be possible!!!
> >



________________________________________________
Message sent using UebiMiau 2.7.2

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
Discover Yahoo!
 Use Yahoo! to plan a weekend, have fun online & more.  Check it out!