|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
April 25th 06, 09:30 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Here's a challenge - VBA regarding mail
ok, I'm not a pro, but this task seems like an extremely
difficult task - so hopefully someone is up to the challenge! I have a MS Access 2003 database. I would like to use VBA to accomplish the following tasks (keep in mind this is originating from Access and not Outlook)... I would like to take an email address and instead of creating a new message to it I would like to REPLY to the last one that was received from that address. Obviously the only real difference is that the body of the message from the previous received message will be included. Keep in mind I am talking about sending a message programatically (although it needs to use Outlook as a client). 
|
| Ads |
|
#2
April 26th 06, 05:32 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Here's a challenge - VBA regarding mail
Am Tue, 25 Apr 2006 15:30:54 -0500 schrieb Stealth1:
If all e-mails you want to consider are in the Inbox of Outlook then you can sort them by the Sort method retrieve all items received from that address by the Restrict function. Take the first item received and call its Reply function. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- ok, I'm not a pro, but this task seems like an extremely difficult task - so hopefully someone is up to the challenge! I have a MS Access 2003 database. I would like to use VBA to accomplish the following tasks (keep in mind this is originating from Access and not Outlook)... I would like to take an email address and instead of creating a new message to it I would like to REPLY to the last one that was received from that address. Obviously the only real difference is that the body of the message from the previous received message will be included. Keep in mind I am talking about sending a message programatically (although it needs to use Outlook as a client).
|
|
#3
April 26th 06, 02:35 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Here's a challenge - VBA regarding mail
If all e-mails you want to consider are in the Inbox of Outlook then you
can sort them by the Sort method retrieve all items received from that address by the Restrict function. Take the first item received and call its Reply function. And this can be done from MSAccess?
|
|
#4
April 26th 06, 05:03 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Here's a challenge - VBA regarding mail
Am Wed, 26 Apr 2006 08:35:50 -0500 schrieb Stealth1:
Yes, it can. Add a reference onto Outlook via Tools/References. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- If all e-mails you want to consider are in the Inbox of Outlook then you can sort them by the Sort method retrieve all items received from that address by the Restrict function. Take the first item received and call its Reply function. And this can be done from MSAccess?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I challenge anyone to answer this one.................Do you dare? | Challenger | Outlook - Installation | 4 | May 3rd 06 05:59 PM |
| A difficult VBA question...a challenge | Stealth1 | Outlook - General Queries | 2 | April 25th 06 09:28 PM |
| Spamming Challenge! | [email protected] | Outlook - General Queries | 4 | April 25th 06 02:08 PM |
| Run VBA Code from 'new mail message' on standard toolbar | Carmi | Outlook and VBA | 8 | March 31st 06 05:53 PM |
| Using VBA to edit mail body without losing embedded pictures? | [email protected] | Outlook and VBA | 2 | March 20th 06 07:38 PM |
Linear Mode
