Sending shipping info when table updated.

[Strangeway]

Hi guys,

I'm a big of a VBA noob and I have a big task that I need to get going. Essentially, I have an Excel spreadsheet that contains shipping information for all orders processed in a day. What I would like to do is import that spreadsheet to my Access DB, have Access compare the customer IDs against my master list, and send an email to each customer indicating that their order shipped. I would also like the body of the email to contain the relevant info (number of cartons, weight, etc.)

I am sure something like this has been done a hundred times in various Access applications, but I'm having trouble finding any code samples or references on the net.

Any tips would be greatly appreciated.

Cheers.

 

[simian101]

It appears you have a 3 part problem.

1. import that spreadsheet to my Access DB

look up DoCmd.TransferDatabase acImport
you can also do it manually by going to file>get extenal data>import

2. have Access compare the customer IDs against my master list

This should just involve a few simple queries.

3. send an email to each customer indicating that their order shipped.

Just search the forums for sending email access and you will find lots of examples.

Simi