How do i collect data from 2 tables in 1 email?

[nickblitz]

as above.

please advise!

 

[mahenkj2]

Can you elaborate further? Nobody would make out where the problem is.

 

[nickblitz]

under external data tab theres this thing called create email.

i want to collect data to update existing data from 2 tables. i realize that i can't because access only allows me to get from 1 table.

 

[mahenkj2]

That’s why I asked details. As you correctly understand that “Collect data via Email” needs a single table if you want to update data. To make this happen, you have to think in such a way that your multi tables convert or resemble into a single table. The means are use of some action queries such as Make table. Also, you may need to use Update query or statement, delete query etc.

So it might be helpful to think in this direction if you do not have other option for data collection by email.

I am also very new to access but used this feature with experimentation, but I have not used any other methods.

Regards.

 

[nickblitz]

That’s why I asked details. As you correctly understand that “Collect data via Email” needs a single table if you want to update data. To make this happen, you have to think in such a way that your multi tables convert or resemble into a single table. The means are use of some action queries such as Make table. Also, you may need to use Update query or statement, delete query etc.

So it might be helpful to think in this direction if you do not have other option for data collection by email.

I am also very new to access but used this feature with experimentation, but I have not used any other methods.

Regards.

thaNKS for the reply.

i am trying out word merge now.

 

[mahenkj2]

Remember, when I said merge two tables, does not necessarily mean that you combine two tables in one just breaking rules or requirement, instead try other means which I mentioned in my previous post.

 

[nickblitz]

Remember, when I said merge two tables, does not necessarily mean that you combine two tables in one just breaking rules or requirement, instead try other means which I mentioned in my previous post.

word merge does the exact same thing. it extracts data from the query that merges the 2 tables and put them in a HTML format that can then be forwarded to the recipients based on the email which is in the tables. this is exactly whAT i expect create email to do for me but no. lol!