+ Reply to Thread
Results 1 to 4 of 4

excel data range not copying into gmail mail body in html format

  1. #1
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    excel data range not copying into gmail mail body in html format

    HI,


    I wrote a code to send automails. i convert excel range to "HTML" file. but I could not read html file and copy into gmail body. Please help me.
    Please go through the first attachment for sample output & go through the second attachment for macro file.


    regards
    shiva
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by shiva_raj; 03-24-2019 at 12:19 AM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,575

    Re: excel data range not copying into gmail mail body in html format

    Using Ron de Bruin's RangeToHTML() is the usual method. https://www.rondebruin.nl/win/s1/outlook/bmail2.htm

  3. #3
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: excel data range not copying into gmail mail body in html format

    hi,

    Thank you for reply. but, iam using gmail. please go through my second attachment and correct the code. i cant understand that where the mistake occured. why vba code not pasting excel range in Gmail in html format.

    regards
    shiva
    Last edited by shiva_raj; 03-25-2019 at 12:12 AM.

  4. #4
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: excel data range not copying into gmail mail body in html format

    Cross Post HERE
    Click the * Add Reputation below to say thanks.

+ 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. How to insert cell value and format into HTML Mail body
    By SOFL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2017, 12:33 PM
  2. Replies: 1
    Last Post: 02-09-2017, 01:05 PM
  3. Using HTML Body Format in Outlook mail
    By akash kothari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2014, 11:33 AM
  4. Sending mail with range as body using GMAIL
    By vssoma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 05:40 AM
  5. Replies: 1
    Last Post: 06-12-2012, 11:13 AM
  6. how to use t his fnsafesendemail function to mail report in html format
    By okl in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2010, 08:47 AM
  7. Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message
    By ITAnnaJones@gmail.com in forum Excel General
    Replies: 0
    Last Post: 07-10-2006, 10:09 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