Emailing to multiple people

First - I don't know VBA very well at all.

I have report that I want to email to multiple users that give them the
quantities of their Inventory parts only. So I need something that will loop
through each user and send them a report (as an attachment) with only their
information in it.

There are about 60 people to email to. I have used the macro send command but
that allows for only static name at a time...so it won't work for these
purposes.

Anyway I can get this done without knowing VBA very well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200706/1

.

Relevant Pages

  • Re: Is ADO dead?
    ... Microsoft is really eliminating Access and VBA. ... definitions and reporting in XML. ... Server Express without VBA definitely seems to be where MS is ... No VBA behind a report. ...
    (comp.databases.ms-access)
  • RE: STORE USER ENTRY for Later Use & Replace Bat file with Access
    ... office applications use VBA. ... FileCopy gbl_UserInput, DestinationFile ... The Macro opens a report based on a query. ...
    (microsoft.public.access.queries)
  • Re: Is ADO dead?
    ... MSDE is more dead than DAO, in that there is no longer any ... as SQL Server Express more than takes ... Server Express without VBA definitely seems to be where MS is heading. ... They are keeping the same report designer UI and adding a new Layout ...
    (comp.databases.ms-access)
  • Re: Checking tables and column names using VBA
    ... controls on forms, VBA variables in code, queries, modules, reports, etc. ... Is there a way to rename every occurrence of a table, column, ... form control, query, report, macro or module from "ItemNamedX" to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Is ADO dead?
    ... as SQL Server Express more than takes ... Microsoft is really eliminating Access and VBA. ... and reporting in XML. ... They are keeping the same report designer UI and adding a new Layout ...
    (comp.databases.ms-access)