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 ~
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: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar