Re: 116338 Re: [MS_AccessPros] Sending email from access

 

Hi Crystal,

Sorry for coming back after many days.

The work we have done up to now is OK and it is almost done. We only have to pick email addresses whose birthday is on the current date.

Well, i have the idea that on the form "Notification3" i should put a command button with caption something like "Send Birthday Wish".

Form "Notification3"  Record Source is "qryHappyBirthday" with Sql:

SELECT Members.MembershipType, Members.MembershipTitle, Members.MemberID, Members.SurName, Members.GivenName, Members.GenderStatus, Members.DesignationSOC, Members.Dob, Members.PlaceOfBirth, tblContactNumbers.TelephoneResidence, tblContactNumbers.MobileNo1, tblElectronicContacts.MemberEmail

FROM (Members INNER JOIN tblContactNumbers ON Members.MemberID = tblContactNumbers.MemberID) INNER JOIN tblElectronicContacts ON Members.MemberID = tblElectronicContacts.MemberID

WHERE (((Month([Dob]))=Month(Date())) AND ((Day([Dob]))=Day(Date())));

This query is working perfectly.

So please look for it from your precious time, perhaps we will have to make a new query deriving from above query and remove unnecessary fields and use them on the command button "Send Birthday Wish".

Regards,

Khalid

 

 

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

hi Kalid,

>> pick email address of all members whom birthday is on

the current date <<

that means that either:

the code has to open the recordset and step through records and change variables -- or the code to loop will be a procedure that calls this code and then send parameters for the variables.  You need to decide how this will be done.

>> From the beginning i am asking <<

... please also realize I asked you to define a query to give the information that the email needs. So far, I haven't seen that. Perhaps I missed it?

respectfully,
crystal
 
~ have an awesome day ~

On 6/19/17 2:29 PM, khalidtanweerburrah@... [MS_Access_Professionals] wrote:

Hi Crystal,

The thing you are telling me does works if i put a real email address instead of "someone@..." it does opens outlook. This means i already have the reference to outlook.

From the beginning i am asking that it should pick email address of all members whom birthday is on the current date. I need something to complete this task.

Please consider upon it and guide if possible.

Regards,

Khalid

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

hi Kalid,

CHANGE someone@... to a real test email address

Does the code compile successfully?  You may need to reference the Microsoft Outlook #.# Object Library.

respectfully,
crystal
 
~ have an awesome day ~

On 6/16/17 6:15 PM, khalidtanweerburrah@... [MS_Access_Professionals] wrote:

Hi Crystal,

I'm yet unable to create mailing list.

I assume something had to be done in mod_EmailOutlook

   'this information could be passed as parameters

   sMailTo = "someone@..."  <===============

   sSubject = "My subject line"

   sBody = "My message"

   sPathFileAttachment = "C:\Users\tanwe\Desktop\Today for sending email.txt" 'or whatever this is

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please help.

Best regards,

Khalid

__._,_.___

---

Posted by: khalidtanweerburrah@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___