how can I Send the data from Access using an emailing system?

I'm doing this project and as part of that project i need to be designing my
system using microsoft access so that it would enable the sending of the most
updated data each week to this other office using the emailing system. can
some please make suggestions on how i would be able to make my access system
to do so? thanks

The big question is do you want to automate Outlook specifically for sending
these e-mails, or any installed MAPI compliant e-mail program?

If the latter, you can use Access' built-in SendObject command (Microsoft
Access Email FAQ - SendObject:
http://www.granite.ab.ca/access/email/sendobject.htm) to send a query,
table, etc. via e-mail. However, you don't have full control over the e-mail
message.

If the former, and you want full control, automate the Outlook Object Model
in your Access project to create, populate and send the e-mail. See this
link for more info:

Microsoft Access Email FAQ - Outlook:
http://www.granite.ab.ca/access/email/outlook.htm

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

"Roshni" wrote:

> I'm doing this project and as part of that project i need to be designing my
> system using microsoft access so that it would enable the sending of the most
> updated data each week to this other office using the emailing system. can
> some please make suggestions on how i would be able to make my access system
> to do so? thanks

DON'T GO OUT OF YOUR WAY TO DO IT THAT WAY.

INSTEAD LOOK UP THE MS FEATURE 'TRACK CHANGES' &| MSDN
SQL &| USE THE EXPORT FEATURE. CREATE A MAILING LIST.
EACH MAIL MESSAGE WILL HAVE TO BE MANUALLY SENT AT THIS
TIME.

>-----Original Message-----
>I'm doing this project and as part of that project i need
to be designing my
>system using microsoft access so that it would enable the
sending of the most
>updated data each week to this other office using the
emailing system. can
>some please make suggestions on how i would be able to
make my access system
>to do so? thanks
>.
>

"Roshni" wrote:

> I'm doing this project and as part of that project i need to be designing my
> system using microsoft access so that it would enable the sending of the most
> updated data each week to this other office using the emailing system. can
> some please make suggestions on how i would be able to make my access system
> to do so? thanks

Eric and anonymous thanks for your help and anonymous can you please explain
more on how to do the thing you've written in your reply e.g. where do i need
to go and what do i need to do (a step by step procedure). thanks