Send email from ms access using query from sql server - recipients are all customers in database RRS feed

  • Question

  • Hello -

    I need code to send an email from Access that will be sent to all customers in the database when their orders ship.  They have to include in their body the shipment date from the query.

    1)  How do I loop through all of the customers to send the email to?

    2) How do I include the shipment date in the body of the email?

    Any help will be greatly appreciated.  I spent all day looking for the answer to this question via Google and have not come across anything.  Please help!!


    Thursday, July 23, 2015 3:39 AM