auto email to client before 30 days of expiry of loan

[ItsMe]

I was started off with a simple example to help build the knowledge for the OP as previous posts haven't given the impression of a massive amount of knowledge and giving a chunk of vba maybe overwhelming.
It's better to understand how the whole process works then botch together things found on the web as if there are errors how will the be fixed.

Fair enough. I just had it in my head that a better approach would be a question like, "Have you tried using the Wizard to email a report?" The video, itself, must have rubbed me the wrong way. Additionaly, I did not taking into consideration any previous posts by the OP. I was only considering the Title of this thread and post #1.

[AlexHedley]

I should have added a bit more explanation when I originally posted it, I was just being a little lazy , I'll be more careful in the future.

[joshynaresh]

with you example i don't understand how to do?

[AlexHedley]

Hi @joshnyaresh,

Which example are you struggling to follow along with?
Mine won't achieve what you require but was there as a stepping stone to understand how an email can be sent through Access, hopefully giving you some knowledge around the area.

@June7 supplied some excellent links that will get you to the next stage in your quest.

The MS article describes how to create an Outlook object and send information using a Function, where you can pass in some arguments.

If you can explain what you've tried and tell us where you are having trouble we can help out.

Alex

[joshynaresh]

l'm explaining from beginning of my work.
i have created query which calculate remaining days.
i have created macro sendobject.

and i got these problem

1 when i run my macro access ask to allow or deny to send my mail
2 even there is no any record in query although email send.

required
1 i don't want to ask me it should be automatically send mail.
2. if there is no any record in query email should no be sent.

Thank You.

[AlexHedley]

1 when i run my macro access ask to allow or deny to send my mail

1 i don't want to ask me it should be automatically send mail.

This is what happens with Access now.
I think pre 2003 it didn't used to but due to security reasons they added this in to stop people doing bulk spam emails.

I'm sure there is a dropdown that stops it from showing for about 30mins but no longer than that.

MS Article
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[AlexHedley]

2 even there is no any record in query although email send.

2. if there is no any record in query email should no be sent.

When are you telling it to send an email?
Is it per record in the Query?
What values does the Query return?

[June7]

1. This is what I did with mine. From Outlook, Window Button > Options > Trust Center > Programmatic Access > Never Warn

2. Post code. Are you cycling through a recordset of email addresses? Open recordset filtered to only addresses that have data.

[joshynaresh]

i have unable to send email to per recordset so i have tried these. after successof these then i will try to send email to per recordset.
Thank You

[joshynaresh]

hello june7

i do not understand your second suggestion.

Thank YOu

[June7]

The second suggestion is for you to provide the code you have constructed so that we can analyze. You have been provided relevant examples to modify for your situation. Show us what you have done.

[joshynaresh]

Hello alex and june7,
I'm using Ms Access 2007. firstly i have tried to send email to recordset email ID but i'm unable to do. so, now i want to send email to "naresh.joshy@gmail.com" all these report which is created by query where i got with some problem. my requirement is - email should not be sent if query have no record.

I also want to ask what should i have to do for sending email to every recordset email ID.

Thank You in Advance.

[June7]

Why are you unable to do so, what happens - error message, wrong results, nothing? Post your code for analysis.

[joshynaresh]

I don't no any thing about sending email code.

[AlexHedley]

So have you created a Macro to send an email?