Replies

The user has a table where they can add or delete email addresses at will. They do not have access to the code to add additional lines of – .Recipients.Add Addressee@Addressee.com – for each email address to appear in the TO: field of the email.

I hope this is clearer.

Thanks

Hi Judy,

I’ve tried .Recipients.Add (“xxxxxx@xxx, zzzzzzz@zzz”) but only the first email address receives the email.

Do you have code that demonstrates how you send a group?

Thanks

Hi Judy,

I’ve tried .Recipients.Add (“xxxxxx@xxx, zzzzzzz@zzz”) but only the first email address receives the email.

Do you have code that demonstrates how you send a group?

Thanks

If I remember correctly, you can create the bat file in Note Pad. Change the file extention from .txt to .bat

In the .bat file you would use dos commands.

copy n:myfoldermyfile.mdb c:mynewfoldermyfile.mdb

If I remember correctly, you can create the bat file in Note Pad. Change the file extention from .txt to .bat

In the .bat file you would use dos commands.

copy n:myfoldermyfile.mdb c:mynewfoldermyfile.mdb

Not sure about vbs but you could do the same with a .bat file.

Not sure about vbs but you could do the same with a .bat file.

Thanks

Thanks

Hi Hans,

Thanks for responding.

As your post indicated I did some digging and this is what I found so far. The MDE opens with a Main form and in the Open Event there is a DoCmd.Maximize. To run the report another form is opened from a button on the Main form. This form also contains in the Open Event, DoCmd.Maximize. Both forms work perfectly.

The error is generated when the processing Notification form is opened. The Notification from also has the DoCmd.Maximize in the Open Event. I removed the DoCmd.Maximize from the Open Event of the form and the error went away. I am in the process of tracking down the next error.

The Notification form contains three labels that notify the user which stage the report is in before it is printed. They become visible for each stage.

Any ideas why the DoCmd.Maximize in the Open Event causes an error on the Notification form and not the other two?

Thanks

Hi Hans,

Thanks for responding.

As your post indicated I did some digging and this is what I found so far. The MDE opens with a Main form and in the Open Event there is a DoCmd.Maximize. To run the report another form is opened from a button on the Main form. This form also contains in the Open Event, DoCmd.Maximize. Both forms work perfectly.

The error is generated when the processing Notification form is opened. The Notification from also has the DoCmd.Maximize in the Open Event. I removed the DoCmd.Maximize from the Open Event of the form and the error went away. I am in the process of tracking down the next error.

The Notification form contains three labels that notify the user which stage the report is in before it is printed. They become visible for each stage.

Any ideas why the DoCmd.Maximize in the Open Event causes an error on the Notification form and not the other two?

Thanks

Excellent!

Excellent!

Hi Charlotte,

Is there a way to modify the code you gave me to extract/view the SQL from/in a query?

Hi Charlotte,

Is there a way to modify the code you gave me to extract/view the SQL from/in a query?