+ Reply to Thread
Results 1 to 2 of 2

Excel Macro to resize the HTML Body

  1. #1
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Excel Macro to resize the HTML Body

    Hi Expert,

    I have this function in excel macro that works on outlook.
    This function use to copy/paste a file to Outlook (HTML body).
    Please help me on how to resize the HTML body that copied/pasted to outlook.
    wheh the HTCL pasted to outlook it display bigger drawing that capture the whole body of outlook.
    Your help is very much appreciated. thanks.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Excel Macro to resize the HTML Body

    Hi, Jovillanueva,

    you would need to set the size in the HTMLBody of the mail not in the Function displayed here (please mind that HMTL only knows 7 font sizes if I remember correctly - standard should be 2, smaller is 1, bigger 3):

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem using loop for sending excel range in email body using Range to HTML code
    By drajanm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2012, 03:17 AM
  2. [SOLVED] Macro to body of email from word & excel - can't get HTML format correct
    By MacroMess in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 01:32 PM
  3. Encode Text Of Body Of Email Into HTML
    By WJO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2012, 02:27 PM
  4. Automate Lotus Notes email with HTML body from excel
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2010, 06:47 PM
  5. Excel macro to send HTML Body email
    By Benjamin2008 in forum Excel General
    Replies: 1
    Last Post: 05-01-2010, 05:29 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1