Devam Ediyor

484177 Access query to send emails

I have the following access query that adds a note into my database to remind me to send my customers an email..

INSERT INTO Notes ( Type, NumericKey, ItemNumber, EntryDate, EntryTime, Notes, Event, FollowupAction, AssignedTo, ScheduledDate, Completed, EnteredBy, Priority, Status, ParentType, ParentKey, AlphaKey )

SELECT "O" AS Type, [url removed, login to view] AS NumericKey, "0" AS ItemNumber, Date() AS EntryDate, Time() AS EntryTime, "Send email for feedback request" AS Notes, "Send Feedback Email" AS Event, "Send Feedback Email" AS FollowupAction, "Admin" AS AssignedTo, Date() AS ScheduledDate, "0" AS Completed, "Webfiles" AS EnteredBy, "Information" AS Priority, "n/a" AS Status, "O" AS ParentType, [url removed, login to view], " " AS AlphaKey

FROM Orders LEFT JOIN [A999-07B Orders that we have added notes to request feedback] ON [url removed, login to view] = [A999-07B Orders that we have added notes to request feedback].NumericKey

WHERE ((([A999-07B Orders that we have added notes to request feedback].NumericKey) Is Null) AND ((Date()-[Orders]![ApprovalDate])>15) AND (([Orders]![ApprovalDate]-[OrderDate])<11) AND (([url removed, login to view])="AZ") AND (([url removed, login to view])=Yes) AND ((Date()-[Orders]![OrderDate])<90));

I'm looking for someone to take this query and rather than add a note to send the email

1) Send out the needed email to my customer

2) CC me in on the email

3) Add a note into the database table "notes" saying the email was sent.

I would like the emails to go out SMTP, (requires authentication), or at a last resort, send out through outlook.

Beceriler: Her şey Kabul

Daha fazlasını görün: time in az, request feedback, n query, send query, send emails, query table, az, smtp email access, access query table, authentication needed, access notes database, query email, access table query, admin access, access event database, outlook add database, notes outlook, outlook email access database, send smtp access, smtp access, customer feedback access database email, send smtp email access, event database access, request emails, email smtp access

İşveren Hakkında:
( 7 değerlendirme ) Youngstown, United States

Proje NO: #2230087