SendObject

[Joe8915]

I have a report that I want to send out every week. So what I did is use a macro to SendObject. The (company) email that I am using is Lotus Notes. I have to use a "group" to send. With in that group are 30 individuals. Everything works ok, but my problem is, it goes only to me but not to everyone else. I tested the email address from home (just using a small message and it works fine. Have any ideas. I hate to list all the users in that group to send the report but I guess if I have to I will. (which I already tried). I haven't figure out how to seperate the names yet. Should I use a comma or colon or??????

Thanks for taking the time to read this and for the help in the past

 

[spacepro]

You can add the ';' symbol to seperate email address. Even better would be to convert the macro to vb.

You can then trap errors and customise if the sendobject fails for whatever reason.

Andy

 

[Joe8915]

Ok being a newbie to vb, could you show me the code

thanks

 

[spacepro]

You could convert your macro to vb by selecting the following from the Menus.

Tools > Macro > Convert Macros to VB.

This will convert the code to vb, then in the visual basic editor edit the code to enter your additional email addresses.

or enter the following code

Docmd.sendobject ...........

As you enter the above code the vb editor will highlight the arguments required, you just enter what it asks for.

There are plenty of posts with the correct syntax, if you have problems then post and I will post you an example.

Andy

 

[Kevin_S]

Instead of hard coding in all of the email addresses you may want to pull these from a table instead... Reason I say this is what happens when you need to change an address/ add a new one/ remove someone/ etc... ??? You now have to make changes to the whole db. By looping through a table you eliminate this problem. Have a look at this post here . It's along the same lines and has links to info about the SendObject statement...

HTH,
Kev