Collect Email via Query

[mrmims]

Hello,

I am trying to Collect Data via email generated from a Query.

The query is based off of a single table, and a few IS NULL Criteria to weed out data not in need of updating.

SELECT tbl_Axes.AxisNumber, tbl_Axes.AxisName, tbl_Axes.LowerSoftPosition, tbl_Axes.UpperSoftPosition, tbl_Axes.AxisNumberofLines
FROM tbl_Axes
WHERE (((tbl_Axes.LowerSoftPosition) Is Null)) OR (((tbl_Axes.UpperSoftPosition) Is Null)) OR (((tbl_Axes.AxisNumberofLines) Is Null))
ORDER BY tbl_Axes.AxisNumber;

The query runs great, returning exactly the information I need (about 20 records)

But when I run the Collect Data via Email wizard, it sends an email with only 1 blank record.

What am I doing wrong?

I can run the wizard on the table with those specific fields, but it sends an email with all record, 75 of which do not need updating?

Thank you for any and all help!

[rpeare]

What is your code running the export and subsequent email generation?

[mrmims]

Using the Access 2010 wizard. Right clicking on the query and then clicking "Collect Data via Email".

[rpeare]

So you're not running code. Your original post was a query that selected items from a table, what is your process related to that query? Are you mailing that query out expecting a user to fill in some information, then return the email to you where you harvest what they entered? If you are running a wizard I do not have that wizard in Access 2007 following this:

https://support.office.com/en-us/art...0-689ba00a48e0

If you are doing something other than this please explain what it is.