Email Query fields

  • Thread starter Thread starter Kelli
  • Start date Start date
K

Kelli

I actually have 2 questions in regards to this.
1) Is it possible to send only part of a query in an
email. For example, I have a list of vendors and parts we
want to purchase from them. I have an email field for each
vendor. I only want to send each vendor the rows with
their parts, not the entire query. Not sure if it's
possible to break it up.

2)Regardless of above, I'm having trouble pulling the
email from the Query.

=Query![Tobuy with Emails]!

This is what I hav ein the To: field, but keep getting
error, saying it can't find the name Query.

Thanks,
Kelli
 
To send just the records that are for a given vendor, you must put a
criteria in the query that limits the records to that vendor. Likely this
means that you either need to use a parameter in the query (asking you which
vendor) or you'll need to use VBA (not a macro) to loop through a recordset
that is based on a list of vendors, create queries, then email the
individual queries.

Your syntax
Query![Tobuy with Emails]!
isn't working because it's not correct. You cannot access a query using this
syntax (there is no Query collection). Again, you'd need to use VBA to get
the name of the vendor, or use the DLookup function to get the vendor's
email address from a table or query.

If you can post more details about the queries, tables, email operations,
etc., we'll see if we can help you get the results you desire.
 
Back
Top