+ Reply to Thread
Results 1 to 2 of 2

Outlook Email Table Optimisation

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    Jozi, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    93

    Outlook Email Table Optimisation

    Hi all,

    I am creating a module in Outlook VBA to optimise tables within an email.

    My intention is to reduce the number of clicks I need to perform to: Autofit contents, Reduce row height and Align text in cells to left and top ; by adding a macro and just clicking a ribbon button once off to do all the functions.

    I have the below code which is working forAutofit contents and Reduce row height. But I am having a problem coding the Align text to Left and Top of each cell.

    I cant use Styles as the tables have rows of varying color depending on the data in the row.

    Andy ideas ?

    Please Login or Register  to view this content.
    ***------ Coding for Fun ------***

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Outlook Email Table Optimisation

    you almost had it

    Please Login or Register  to view this content.
    Last edited by Gregor y; 06-22-2018 at 06:24 PM. Reason: forgot to uncomment a line at the beginning
    If it'd make you feel better using my answer because of my street cred, then you can go ahead and click Add Reputation below to improve it.

+ 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. [SOLVED] excel to generate outlook email with html table
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 05:44 AM
  2. Split Table and Email out (Windows, Outlook)
    By Cynops in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2016, 01:29 PM
  3. Copy a table in an open outlook email into excel using VBA
    By Luigi Ribeiro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2016, 12:26 PM
  4. [SOLVED] Read from table inside outlook email
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2015, 09:43 AM
  5. VBA : Paste Word.Table into Outlook email
    By Dt12345 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 01-25-2015, 04:53 PM
  6. Pasting Table Autoformat into Outlook Email Body
    By frolicols in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 11:30 AM
  7. Send data table from Excel to outlook as Email
    By praky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 04:31 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