CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2017
    Posts
    7

    Not reading for loop, can't send outlook mail

    I have implemented my work, but the mail is not getting sent. Infact, the compiler can't reach the "for" loop. I have to extract the rows(A-H) where character "d" is present. Suppose if "d" is present in column "M" at "M6" cell, then I need to extract A6-H6 and send it via outlook mail.

    Please help me!

    This is what I have done so far :

    Code:
    using System; 
    using System.IO; 
    using System.Collections.Generic; 
    using System.Linq; 
    using System.Text; 
    using Excel = Microsoft.Office.Interop.Excel; 
    using Outlook = Microsoft.Office.Interop.Outlook;
    
    using System.Collections;
    
    namespace XYZ 
    { 
    class Program 
    { 
    //method to send email to outlook 
    public static void sendEMailThroughOUTLOOK() 
    { 
    try 
    { 
    // Create the Outlook application. 
    Outlook.Application oApp = new Outlook.Application();
    
    // Create a new mail item. 
    Outlook.MailItem oMsg = 
    (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);
    
    // Set HTMLBody. 
    //add the body of the email 
    oMsg.HTMLBody = "See the details";
    
    //Subject line oMsg.Subject = "Doc Info";
    
    // Add a recipient. 
    Outlook.Recipients oRecips = (Outlook.Recipients)oMsg.Recipients;
    
    // Change the recipient in the next line if necessary. 
    Outlook.Recipient oRecip = (Outlook.Recipient)oRecips.Add("abc@xyz.com"), oRecip.Resolve();
    
    // Send. 
    oMsg.Send();
    
    // Clean up. 
    oRecip = null; 
    oRecips = null; 
    oMsg = null; 
    oApp = null; 
    } 
    catch (Exception ex) 
    { 
    } 
    }
    
    private static string EX_PATH = @"F:\Document_Excel.xlsm"; 
    private static Excel.Workbook AXBook = null; 
    private static Excel.Application AXApp = null; 
    private static Excel.Worksheet AXSheet = null;
    
    public static string exception = "";
    
    static void Main(string[] args) 
    { 
    if (args == null || args.Length < 4) 
    { 
    Console.WriteLine("Let's start the work!"); 
    Console.WriteLine("press any key to continue"); 
    Console.ReadLine(); 
    } 
    else 
    { 
    AX_PATH = args[0]; 
    }
    
    AXApp = new Excel.Application(); 
    AXApp.Visible = true;
    
    exception = ""; 
    try 
    { 
    AXBook = AXApp.Workbooks.Open(AX_PATH, 0, true, 5, "", "", true,Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); 
    } 
    catch (System.Exception ex) 
    { 
    exception = ex.Message; 
    }
    
    exception = ""; 
    try 
    { 
    AXSheet = (Excel.Worksheet)AXBook.Sheets["Sheet First"]; 
    } 
    catch (Exception ex) 
    { 
    exception = ex.Message; 
    }
    
    Console.WriteLine("Hello");
    
    Excel.Range last = AXSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing); 
    Excel.Range range = AXSheet.get_Range("A1", last); 
    int lastUsedRow = last.Row; 
    int lastUsedColumn = last.Column;
    
    Object missing = System.Type.Missing; 
    for (int i = AXSheet.Cells.get_Range("d", missing).Row + 1; i <= last.Row; i++) 
    {
    
    Console.WriteLine("Hello"); 
    sendEMailThroughOUTLOOK(); 
    }
    
    } 
    }
    
    }
    Last edited by 2kaud; April 14th, 2017 at 02:46 AM. Reason: Added code tags

  2. #2
    2kaud's Avatar
    2kaud is offline Super Moderator Power Poster
    Join Date
    Dec 2012
    Location
    England
    Posts
    7,553

    Re: Not reading for loop, can't send outlook mail

    [When posting code, please use code tags so that the code is readable. Go Advanced, select the formatted code and click '#'.]

    Cheers!
    All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain https://creativecommons.org/publicdomain/zero/1.0/ and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!

    C++20 Compiler: Microsoft VS2019 (16.11.5)

  3. #3
    Join Date
    Apr 2017
    Posts
    3

    Re: Not reading for loop, can't send outlook mail


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured