Call a Public Outlook sub from Access

[Andrew]

Hi

Can anyone help me please?

I have written a Public Sub in a standard module within Outlook. I want
to be able to call that sub from elsewhere - specifically from a VBA
routine within Access.

I don't know a lot about Outlook VBA - most of my work is done within
Access - but I believe that if I want to avoid the security features of
Outlook that prevent automatic sending of emails (I want to be able to
send dozens at a time to clients stored in an Access table) this may be
possible if I call code written in Outlook rather than writing the
equivalent code in Access. Is this correct? Or can anyone help me
further?

Thanks in advance

Andrew

 

[Andrew]

Apologies. Have reposted elsewhere.

Andrew

Your question would be better put in one of the .vba groups.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters