Got the code, but can't make it run

[froggiebeckie]

I'm having a total brain freeze here.

Last week, I posted for help getting an email (with attachments) sent from inside an Access database.

With some help from my friends here, I fought through the issues and got the code in the module to work, when tested from the immediate window.

Problem is, I can't figure out how to tie it to a macro or event or anything else that will let me push a button and have it run.

I need nuts and bolts details--- how do I run this module?

BeckieO

 

[boblarson]

In a command button's click event you can call it:

Call YourFunctionOrSubNameHere

But you would have needed to put the code you got earlier in a STANDARD module (not a form module) and don't name the module the same as the function or sub. Also make sure it starts with PUBLIC and not PRIVATE.

 

[froggiebeckie]

Works Like a Charm

Thanks again--you broke it down to my level, and it appears to be working fine.

Hope some day I'll be able to provide support for someone else, too.


BeckieO

 

[boblarson]

Hope some day I'll be able to provide support for someone else, too.

I'm sure you will.