Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

programmer needed

Status
Not open for further replies.

kgott

Technical User
Jun 8, 2007
1
US
Situation: Every day I synchronize my memos from the Visor to Microsoft Outlook.
I need the following Program: After synchronization and invoking the macro, outlook saves the notes in a csv file (which is a running record of all memos synchronized), then outlook emails the notes to a specified email address, and subsequently the notes from the most recent synchronization get deleted from the outlook notes folder.
Does anybody know a programmer who would like to work on that? how much would it cost?
 
if you want me to make this macro send a mail with the full specification (mailto:ide@altavista.net).

this sub (VBA) create a mail from notes items (you must set the PersFolderFileName and NotesFolderName values), saves as a txt file, and displays the mail item.

if it's enough and works, it costs a star ;-)

ide

Code:
Sub NotesMailSend()
    Dim PersFolderFileName, NotesFolderName, MyText As String
    Dim myOlApp, myNameSpace, myFolder, myItem As Object
    
    PersFolderFileName = "matusjInbox" 'your personal _
    forder's name
    
    NotesFolderName = "Notes"
    
    Set myOlApp = CreateObject("Outlook.Application")
    Set myNameSpace = myOlApp.GetNamespace("MAPI")
    Set myFolder = myNameSpace.Folders(PersFolderFileName)
    Set myFolder = myFolder.Folders(NotesFolderName)

    For i = 1 To myFolder.Items.Count 'set the myMail's text
        MyText = MyText & myFolder.Items(i).CreationTime & _
        Chr(10) & myFolder.Items(i).Body & Chr(10) & Chr(13)
    Next i
    
    Set male = myOlApp.CreateItem(0) 'create a simple mail
    
    male.Body = MyText
        
    male.Recipients.Add ("Matus, József") 'To address 1
    male.Recipients.Add ("ide@altavista.net") 'To address 2...
    male.Recipients.Add ("asdf@asdflkj.adsfjk.com")
        
    male.Subject = "MyNotesBackUp " & Format(Int(Now()), "mmm.dd.yyyy")
    'mail subject
    
    male.SaveAs "C:\temp\" & male.Subject & ".txt", olTXT
        'save as a simple txt in the specified folder
    
    male.Display
End Sub

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top