more efficient way to send an email through outlook

[Simple input]

thx in adv for help

I've built a 1 table database that's purpose is to keep track if invoicing
dates for 4 different accountants. each accountant has invoicing due, for
1particular account, monthly, quarterly, or annually. I would like to
automate the database to weekly send out reminders to each individual
accountant. I know absolutely nothing about coding... well i can't say
"absolutely" I do know how to at least open the screen... but seriously
that's the extent of my knowledge. I have begun using macros which seems to
work but now i'm having an issue with "allowing" Access to send an email via
Outlook.

 

[vbasean]

Programming is all about approach and current knowledge. If you know
little to nothing about VBA and you want to accomplish the above task
you've got quite a task ahead of you. What your asking can be done
(and has been.) If you want to do it yourself you've got a big
learning curve which starts with VBA. otherwise... $$

 

[a a r o n . k e m p f]

if your database developer had just used SQL Server-- instead of
Access-- then you could just fire a query

XP_SENDMAIL '(e-mail address removed)', 'this is a test subject', 'test
message body'.

Something along those lines.

Access MDB doesnt' really support this new fangled thing called
'functionality'.

-Aaron

 

[Tony Toews [MVP]]

I've built a 1 table database that's purpose is to keep track if invoicing
dates for 4 different accountants. each accountant has invoicing due, for
1particular account, monthly, quarterly, or annually. I would like to
automate the database to weekly send out reminders to each individual
accountant. I know absolutely nothing about coding... well i can't say
"absolutely" I do know how to at least open the screen... but seriously
that's the extent of my knowledge. I have begun using macros which seems to
work but now i'm having an issue with "allowing" Access to send an email via
Outlook.

You will need to get into VBA a bit.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Warning! Tony is a known troll that reccomends DAO if and when it is
not reccomended.

It is reccomended that you move to SQL Server in order to use the
'best in breed' tools that include
- being able to send email
- only having to configure email in _ONE_ place
- not having to suppress 'someone is trying to use outlook' warning
messages

If you just moved to SQL Server; you'd be done by now.

And with SQL Server; you can easily keep track of 'which emails have
been sent' and 'where they are going to'.

Try doing _THAT_ with MS Access _OR_ Outlook.

-Aaron

 

[Tony Toews [MVP]]

Note that Aaron's answer to just about every question is SQL Server
and ADPs. No matter how appropriate his answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[access.slut]

Do you see a question about SQL-Server? Do email problems concern the
database or the api layer between the database and the mail transport
protocol? Do you have any idea at all what your talking about? Before
you open your foul mouth, the answer is no. You are a total moron who
belongs in an institution, not anywhere where decent people try to
solve problems. Go play with yourself somewhere else.

 

[a a r o n . k e m p f]

Yes.. I do see a question that is 'best answered by SQL Server'.

It involves 'sending your emails from _ONE_ server instead of a dozen
desktops' because it is easier to configure in that manner.

You don't need to sit there and say 'ok' to every single prompt that
says 'OMG, someone is trying to use _OUTLOOK_'.

I mean... do you want to configure it in one place or in 20.

Having it in a single place-- is _ALWAYS_ more secure than having it
in 20 different desktops.
and it's more functional

and you can easily log / blacklist emails

now try doing _THAT_ with 20 different copies of outlook on 20
different machines.

-Aaron