Prev: pdf
Next: MS Access 2007 User permissions
From: a a r o n _ k e m p f on 12 May 2010 09:25 you've gotta tell us more about what you're trying to do dude if you want to import from the sent items folder, then just right- click import, files of type = 'outlook' and then browse for the sent items folder Bob Vance wrote: > I am wanting to enter tblOwnerInfo.LastName,"," TblOwnerInfo.FirstName with > the tblOwnerInfo.Email (Address) to Sent Items to box? > Is this Possible > > strMail = Nz(DLookup("Email", "tblOwnerInfo", "OwnerID = " & lngID), "") > > > Public Function OwnerEmailAddress(idOwner As Long) As Variant > > If IsOwnerWithEmail(idOwner) Then > OwnerEmailAddress = DLookup("[EMail]", "tblOwnerInfo", "[OwnerID]=" > & idOwner) > Else > OwnerEmailAddress = Null > End If > > End Function > > > > > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3
|
Pages: 1 Prev: pdf Next: MS Access 2007 User permissions |