Emailing my results

[ECEK]

I have 200 golfers who send me data. I have built a form that has a cobi-box so I can look at each individuals "Dashboard".

What I want to do is email each golfer their own dashboard.

My initial thoughts are to work out how to do one ie. create an excel file and email it to each golfer (who's email address I have stored) then "loop" a program.
I can't do VBA very well so i'd probably do it via macros.

Can anybody point me in the right direction.

 

[Bilbo_Baggins_Esq]

I haven't used the old fashioned macros in many long years.

looking in Access 2010, it does still contain the "EMailDatabaseObject" item so presumably you could hunt and pect your way through it till it works.

I would personally advise to start learning VBA and use it.
You may struggle at first, but then you get much more flexibilty than with macros.

 

[GinaWhipp]

Hmm, I would use a Report to do this. Then VBA because you cannot do a Loop like this with a Macro. Here's an example of how to do what you want...
http://www.access-diva.com/vba16.html

Don't panic we are here to help you thru it.