K
KAitchison
Good Morning,
I am having a bit of an issue with email data collection in Access 2007.
Here is a run down of the problem
What I want to do:
I want to have users be able to update a record via email. Basically we
have keep track of events that get scheduled and then I want people to be
able to email in to mark them as complete (they have to fill in a couple of
fields on the reply email).
Database Info/Problem:
I have one table called tbl_CT_Data and I can send emails by right clicking
this and choosing collect data by email. This table has a User feild that
each event is assigned to a User and that is linked to a seperate table
(tbl_Users) that houses Users and their Email Addresses.
The problem with this is that I seem to have no control of which records
Access sends in the email for update and I can't seem to send emails to all
people who have events assigned to them.
What I have tried:
I have created a query that selects the record information filtered by 1) a
specified user and 2) their events for a specific date/time period. It is a
select query and will show the only the records that I want the email for.
At first I created this query so that it included the info from tbl_CT_Data
and the email address from tbl_Users. It was read only so it would not send
emails for data collection.
So I made it so that the query has only data from tbl_CT_Data and it has a
realationship so that the User fields are linked.
The problem that I am now having is this:
I right click the query click and choose collect/update data via email, I
can go through the wizard to the end, and when I click send it gives me a
message that says that the email address are invalid or there is no data and
the email does not send. I have not made any changes to the email address
and tripple checked that they are typed in correctly and the query does
return the records that I want updated.
I was hoping someone might be able to help me get this working. I'm not
sure how access is choosing which records to send for update, and why when I
dont use the query, I cannot email some people who have events assigned, but
I can email others.
I am also stumped at why I can email from the table with no filters but when
I try from the query I get these errors.
I apprecate any help.
Thank you,
Krista
I am having a bit of an issue with email data collection in Access 2007.
Here is a run down of the problem
What I want to do:
I want to have users be able to update a record via email. Basically we
have keep track of events that get scheduled and then I want people to be
able to email in to mark them as complete (they have to fill in a couple of
fields on the reply email).
Database Info/Problem:
I have one table called tbl_CT_Data and I can send emails by right clicking
this and choosing collect data by email. This table has a User feild that
each event is assigned to a User and that is linked to a seperate table
(tbl_Users) that houses Users and their Email Addresses.
The problem with this is that I seem to have no control of which records
Access sends in the email for update and I can't seem to send emails to all
people who have events assigned to them.
What I have tried:
I have created a query that selects the record information filtered by 1) a
specified user and 2) their events for a specific date/time period. It is a
select query and will show the only the records that I want the email for.
At first I created this query so that it included the info from tbl_CT_Data
and the email address from tbl_Users. It was read only so it would not send
emails for data collection.
So I made it so that the query has only data from tbl_CT_Data and it has a
realationship so that the User fields are linked.
The problem that I am now having is this:
I right click the query click and choose collect/update data via email, I
can go through the wizard to the end, and when I click send it gives me a
message that says that the email address are invalid or there is no data and
the email does not send. I have not made any changes to the email address
and tripple checked that they are typed in correctly and the query does
return the records that I want updated.
I was hoping someone might be able to help me get this working. I'm not
sure how access is choosing which records to send for update, and why when I
dont use the query, I cannot email some people who have events assigned, but
I can email others.
I am also stumped at why I can email from the table with no filters but when
I try from the query I get these errors.
I apprecate any help.
Thank you,
Krista