Posts by Raha

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hi Team,


    I am trying to append the unmatched query but getting the error message as "Duplicate Output Destination".


    What actually am trying is to identify the unmatched line.

    Eg: in table "A" i have 2 records and in table "B" 3 records

    and i want to append/insert unmatched query result in table "A".


    Should compare or match between "Field1" in both the tables.


    I request you to kindly advise on this.


    Note: I will provide the link in case of cross posting.


    Thank you.


    Regards,

    Rehaman.

    Hi Team,


    So far below coding was working fine to send email from particular account but recently we moved to Outlook 365 - 2013 version and now coding is not recognizing the account and i do not want to use SentOnBehalfOfName.


    Kindly advise and help me with the coding.


    Code
    Sub Which_Account_Number()
        Dim OutApp As object,I As Long      
        Set OutApp = CreateObject("Outlook.Application")      
    
    
            For I = 1 To OutApp.Session.Accounts.Count        
                MsgBox OutApp.Session.Accounts.Item(I) & " : This is account number " & I    
            Next I
    End Sub


    Please note I don't want to use .SentOnBehalfOfName and any coding inside "thisoutlooksession"


    10% paid and here is the transaction ID 50F38114HA831270X


    Thanks in advance for all your help and support.


    Cross posted here: https://www.excelforum.com/exc…ook-365-2013-version.html


    Regards,
    Rahaman

    Hi Team,


    So far below coding was working fine to send email from particular account but recently we moved to Outlook 365 - 2013 version and now coding is not recognizing the account and i do not want to use SentOnBehalfOfName.


    Kindly advise and help me with the coding.

    Code
    Sub Which_Account_Number()
        Dim OutApp As object,I As Long      
        Set OutApp = CreateObject("Outlook.Application")      
    
    
            For I = 1 To OutApp.Session.Accounts.Count        
                MsgBox OutApp.Session.Accounts.Item(I) & " : This is account number " & I    
            Next I
    End Sub


    Thanks in advance for all your help and support.


    Cross posted in "https://www.excelforum.com/excel-programming-vba-macros/1234292-send-email-from-specific-account-outlook-365-2013-version.html"


    Regards,
    Rahaman

    Re: VBA to enter value of one cell into corresponding cells in the same worksheet


    See if this works for you...

    Re: Excel VB Copy & Print Range in Bulk


    To print sheet "pic_format" Range("A1:F8") as jpg use the below code. or if you want the jpg in large size then increase the font size.
    and Please try to adopt the code as per your requirement.


    Re: Excel VB Copy & Print Range in Bulk


    Please try the below code and keep me posted on the working status.

    Re: Vlookup in excel vba


    See attached workbook, adopt as per your requirement if this how you wanted.


    Re: Excel VB Copy & Print Range in Bulk


    Is this how you wanted..?


    Re: VBA Code: excel is hanging at some point


    I have added two extra line in the code and this should work, please try.