Need help Please

[michaelbro]

Good Day

Been browsing here a while and its finally time to make my first post.

I need some urgent help please. I struggle very much with vb code.

What I want to do is send out specific information in table 1 to company ID in table 2 , the company id being the link between the two tables. Table 1 contains transactional info for company in Table 2 . I would like the data to be in excel format sent out via email . The list contains 200 + companies and is currently a manual process that takes forever. I understand this is a very complicated task but how or where can I find the best source to complete this task.


Thanks

Mike

 

[Pat Hartman]

Your request has a few holes that will impact how the procedure would work.
1. Will the spreadsheet go to a predefined list of people or will it go to email addresses located in the company record?
2. Will there be one common set of data or will each company get a customized set of data.
3. What do you want to happen if a company (assuming the email address comes from a company record) doesn't have an email address?
4. What version of Outlook are you using?
5. What version of Access are you using?
6. If you need to create multiple spreadsheets, where do you want them to be saved and how do you want them to be named?

The best way to control selection criteria is with a form. Then the queries reference fields on a form in their Where clause.

Look up the TransferSpreadsheet method to see how to export to Excel.

Look up the OutputTo method to see a simple way to email.