outlook code sync

  • Hi,

    I have 2 separate codes, extension to the earlier post.

    First (Generate Mail), will open outlook mail and insert some text and hyperlink to it ( Still looking for a way to convert link to one word text)

    And second one (by Ron Debruin) which paste excel table into mail.

    How can we combine these 2 so that we have complete mail with text, hyperlinks from first code and table from second code.

    Please suggest, I am sure lot of folks looking out for this solution.

    Attaching file as well.

    Thanks in advance


    Same question has been posted in another forum as well, if got any reply will post here for benefit of others

  • Forget about "generateemail" Sub. You needed to wrap your strBody string in properly formatted HTML code... You then append that HTML string to the RangetoHTML conversion as part of .HTMLbody mehtod.... here is the code:



    Ger

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________

  • Just one thng more...i want to add attachment as well so i have added strlocation as string and then givning "strlocation = "C:\Users\VVA0\Desktop\New folder\Raw Sheet.xlsm" below strbody but it not picking it up.....please suggest what is wrong here

  • Without seeing your current code, its impossible to say, and also not sure what you mean by "not picking it up"... is it a compile error, or just not doing what you expected...? Anyway, the code you need is using a method called .attachments.add


    See Ron's site -
    https://www.rondebruin.nl/win/s1/outlook/amail6.htm


    Using the last piece of code I Pasted above


    It would probably look like this:



    THIS IS UNTESTED CODE.


    But take a read of Ron's page above to see how to add the attachments based on the file name being stored in a cell.


    Ger

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________