General discussion

Locked

Access' SendObject and Email's To: field

By rmann ·
Is there any way to have the SendObject command look at a table for the To: field. I have user info in a table and i need to have either the macro or VBA code look at that table for the Name in the To: field. It's code that runs without the user's input and needs to stay automatic. We customize about 40 apps/databases for this purpose. Any help would be appreciated.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access' SendObject and Email's To: field

by donq In reply to Access' SendObject and Em ...

You might try placing "[Forms]![TableName].[To:]" in the Criteria section of a query that builds your recordset. Eliminate the quotes in your work. I just used them to demo the container,table, and field seporators.

Collapse -

Access' SendObject and Email's To: field

by rmann In reply to Access' SendObject and Em ...

Thank you for trying to help, but for code it will not pull in the name in that field, only the code that i used.

Collapse -

Access' SendObject and Email's To: field

by rmann In reply to Access' SendObject and Em ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Software Forums