Re: [AccessDevelopers] Re: Finding outlook email items and selectively forwarding them

 

With the current code,  it fails the IF check for a mail item and doesn't email anything.

If I comment out the IF -> Endif,  it fails on a type mismatch at

'set objitem = objitem2'

I've read the documentation (outlook VBA) and gotten samples from here and other sites,

but no matter how I manipulate the code (the lines commented out are things I have tried), 

I can't quite get Outlook to recognize the item I have selected and forward it.

Anything you might suggest would be welcomed.

Mike

---

From: GiorgioR <giorgio_rovelli@virgilio.it>
To: AccessDevelopers@yahoogroups.com
Sent: Fri, July 1, 2011 12:39:48 AM
Subject: [AccessDevelopers] Re: Finding outlook email items and selectively forwarding them

 

Mike,
I suppose you mean the Private Sub cmdScan_Click() in frmTest calls the GetEmailSpecificsFromOutlook sub but I see it run to completion, where's the problem?
Giorgio

--- In AccessDevelopers@yahoogroups.com, Mike Wolfstone <mikewolfstone@...> wrote:
>
> Giorgio,
> The code to email forward is in the .bas moduule.
> The code is not complete.  I build my automation apps so I can test them along
> the way and then clean out the chaff.
> The Scan (sub) logic calls the .bas module and that's where I have the problem.
> Mike
>
>
>
>
> ________________________________
> From: GiorgioR <giorgio_rovelli@...>
> To: AccessDevelopers@yahoogroups.com
> Sent: Thu, June 30, 2011 6:00:32 AM
> Subject: [AccessDevelopers] Re: Finding outlook email items and selectively
> forwarding them
>
>  
> Hi Mike, have you written the code to send the chosen item anywhere in the VBA
> code or do you need that?
> Giorgio
>
> --- In AccessDevelopers@yahoogroups.com, "mikewolfstone" <mikewolfstone@>
> wrote:
> >
> > I uploaded the file. It is named FindTeamCust.mdb with a tag of
> >ForwardEmailSelectively.
> > Thanks for any help you can provide.
> >
> > --- In AccessDevelopers@yahoogroups.com, "giorgio_rovelli" <giorgio_rovelli@>
> >wrote:
> > >
> > > Hi, can you upload the mdb/accdb to the Files section?
> > >
> > > --- In AccessDevelopers@yahoogroups.com, "mikewolfstone" <mikewolfstone@>
> >wrote:
> > > >
> > > > I have an Access program that reads the outlook inbox and extracts certain
> >data (subject, objectID, received date) and builds a list of those items. It
> >then selects specific conditions in the subject and further selects those for
> >email forwarding. I can get to that point and identify the item to forward, but
> >the Outlook API doesn't fit the documentation. I need to send (forward) an inbox
> >item to a new email address. Any thoughts?
> > > > The error I get on the activeinspector.currentitem.forward statement is
> >"Method is not supported by the object"
> > > >
> > >
> >
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 3
• New Links 2
• New Files 1

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___