I am trying to send out individual emails to each store letting them know what time the shipment will arrive, using Microsoft Access 2003
Table name is "DelNotification". Fields are "StoreNo", "StartTime", "EndTime", "ShipDate".
Email address will be the 4 digit StoreNo and firstname.lastname@example.org
example: if StoreNo is 1234, email address is email@example.com
the body of the letter will include the StartTime, EndTime and ShipDate. these are the only fields that vary.
and each store will have a different delivery time, that is why it will send out different information for every email.
All the fields will be entered from a form, and user will push a button and it will send the email to all stores.
Hope this makes sense... any help would be greatly appreciated