collect data

  1. T

    Collect/Send data via email Access 2016

    Good Morning, I noticed that CollectDataViaEmail is no longer in my list of options in Access 2016, is there a work around for this? I would like to be able for a person to fill out a form in access and click a button to send an email to the owner of the task. Once he or she receives it, I would...
  2. A

    Collect 500 rows of data daily from 200 users

    Hi, I need your creativity! Problem: I work in a support team in a company where we receive approximately 500 orders per day from approximately 200 users in the company. Currently, these 200 users will either call or e-mail to place their orders. We use approximately 2.5 full time people to...
    • Aqil
    • Thread
    • automate automatic collect data collection data collection
    • Replies: 3
    • Forum: Excel Questions
  3. T

    Macro code that wil look in another workbood to find a date, and average two cells for return answer

    Hi, I am working on a piece of code that will locate a date on another workbook "that date is the value of a formula". Once it has located the date, I need it to average two cells that are located 4 columns over on same row and the cell below that one. I would like the answer to be zero, if...
  4. B

    Collect weight and quantity from list

    I have a list such as herebelow format. Each GID line shows quantity and MEA shows weight. I need a macro to get total of each quantity and weight. As you see quantity and wegiht are not in a specific digit but variable. LIST: GID;1;190;BI; MEA;KGM;20750.50; GID;2;1000;BI...
  5. C

    Access 2007 Multiple Data Table Query with Collect Data

    I have a database in Access 2007 with 3 data tables and 2 relational tables. I have a query that joins the data tables which I would like to use create an email, collect data, and update the results in the underlying data tables. I set up a Simple Query using the Wizard. After chosing the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top