+ Reply to Thread
Results 1 to 10 of 10

Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Dear Forum,

    Basically, I have 2 Queries:-

    Query I - I am using the code available of Google to send emails from Excel to Outllook with some Excel Range Of Cells as Tables in the body of the email, however facing a challenge.
    I have 2 Tables with the data with some Hidden Columns and a Common Header which is Merged.

    When I paste these Tables in Outlook using the code, it shows the Hidden Columns if both the Tables are selected as One Range however if I am selecting them as seperate Ranges then I am not able to place them in the same line as the Tables should be in the same line with a blank Column Gap for readability.


    Query II - I have some text which is put before these tables which is highlighted in Bold Center and with Bigger Font and I need the Tables in the next line with a blank Line for a better view however I get an extra line which I do not know from where this is coming.

    End Sub

    Regards
    e4excel

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Dear Forum,

    I am unable to post the code.. though its already there in the File

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    I have mentioned the challenges as comments in the Code as well so that while referring the code also one can see the specific challenge..

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Bump a Thread.

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Bump A Thread....Please help.....

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Can someone please help me with some suggestion to tweak the code to get the desired result.

  7. #7
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Bump A Thread

  8. #8
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Dear Forum,

    I fail to understand why am I not getting a response on this query..please someone help me or guide me to get the desired result.

  9. #9
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Someone please help me on this......please please please

  10. #10
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Multiple Excel Tables into Outlook Body Next to Each Other in the same Line Using VBA

    Bump A Thread....I have this Query as I am using 2 Different Tables as there are hideen columns in each table...
    Please someone help me

+ 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. Pasting Multiple Ranges into Outlook with Tables AND Charts Using Excel VBA
    By jlive24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2018, 02:39 AM
  2. Extract multiple lines of text from Outlook email body into Excel
    By Ranger75 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2018, 03:47 PM
  3. Replies: 0
    Last Post: 05-28-2018, 09:53 AM
  4. Replies: 0
    Last Post: 09-13-2015, 04:43 PM
  5. Outlook 2013 Copy Body and Subject Line
    By wrasser in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-12-2015, 03:54 PM
  6. [SOLVED] Adding a 2nd line to body of outlook e-mail
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-22-2014, 11:48 AM
  7. Import body of multiple Outlook emails into Excel workbook
    By Ticklekisses in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2013, 04:25 PM

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