Posts by dev99

    Hi,


    Need your help to resolve this.....


    Column A has number or a word for e.g cell A1 has 1000, A2 has again 1000 ,A3 has 2000 and so on...


    I need a formula in B column which will show me exactly how many times its appeared in A column, i dont need the sum count of a word or number .
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]asdf[/TD]
    [TD="width: 64, align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]5[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [td]

    dev

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    1000

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    1000

    [/td]


    [TD="align: right"]
    2[/TD]

    [/tr]


    [/TABLE]

    Hi, i am trying to send a email from lotus notes(version9) below mentionedcode works fine for sometime and than i received debugging error. As i new to VBA I dont know what to replace with the code for Set NUIdoc = NUIWorkSpace.EDITDocument(True, NDoc) and .GotoField ("Body").


    what i want a code for pasting a picture from excel sheet (picture 5) to body of the email, without editing the body for e.g the below code does that but it first goes to body write (.) and again it goes back to body find (.) and paste the picture. i want it to be pasted in the first time itself rather rounding around.




    Any help really appreciated.







    thanks
    Dev