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

 

[John Blessing]

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

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

 

[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