send html table from vba word excel 2000 Results


Sponsored Links:



I've used this code with success:

Set OutApp = CreateObject("outlook.application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = "someone@domain.com"
.CC = ""
.BCC = ""
.Subject = "Subject line"
.Body = "Here goes the body"
.Send 'or use .Display
End With

This code uses the default mail-format in outlook when creating the message.
What I want is to use HTML and genereate a table in the body-field. The important point is the table. I can tell the users to set html as default, but if there is a nice way to change mailformat from VBA as well I would love to know.

So, how can insert html-tags in the mail-body from my vba-code?

I'll be thankful for all suggestions!
-Roy




Last updated Dec 28, 2008 with Database automatic backup tool (2000/XP/2003) from pietersePost# Thread Title Date General Office Solutions 542112Get rid of a hidden instance of Access (and other MS Office applications)15-Dec-05529497Neat trick for creating hyperlink (Office 2K+/I.E.)19-Nov-05411859Searching Microsoft Using Google29-Sep-04104135Correcting corrupted fonts02-Jan-02101007Office 2000 professional (9.0.2720)16-Dec-0193137Help Window as Toolbar (2000 SR1)20-Nov-0148254Display Errors and/or Invalid Page Fault25-Jun-01Access 748557Database automatic backup tool (2000/XP/2003)18-Dec-08700710Faking it - a suggestion (Access All Versions)29-May-08669076Relational design and normalization (Access) 15-Jan-08669075Tips'n'Tricks handout for Access04-Oct-07564953ADO and Access query wildcards (2000/XP)24-Jul-07542112Get rid of a hidden instance of Access (A2K and >)15-Dec-05401468Invalid Wild Card in ADO Sets EOF = True25-Aug-04230516Chr() function and quotes within strings (all)22-Mar-03233244Hidden 'Smart Quotes' in Data (97 & XP)22-Mar-03233732Top Values -- Awesome Solutions by Drew & Mark (97, 2002)12-Mar-03209793Could not find installable ISAM (Access2K SR2)04-Jan-03205252Count Duplicate Records Once (Access 2000)12-Dec-02204170How To Use the CallByName Function in VBA6/A2k11-Dec-02100995Last day of month (Access 97 )24-Dec-0199464Email from hyperlink (Access 2000)12-Dec-0188022Database path in controls (2000)27-Nov-0192735Report OutputTo Text File adds random blank lines16-Nov-0135509Creating a Formatted MsgBox in Access 200005-May-0131802Function not available in Query01-May-0125570Are Relationships Necessary?27-Mar-0116800Filtering for upper case data20-Feb-0116384Query for Upper Case19-Feb-0115668Allow full menu in Startup16-Feb-0114213Emailing Reports in other than Outlook Express ??12-Feb-00Excel 689429Exploding' file size (All)21-Jun-08678267Making long Formulas more readable (All)27-Nov-07669482How to create slanted cell borders22-Oct-07618520Quick way to enter 3D reference10-Dec-06605725Autofilter Highlighter Add-in (All)30-Oct-06603471Force Open code to run after initialization (XL)16-Oct-06602661Using A Range Name to Contain an Array Formula (All)03-Oct-06581649Use named formulas to reduce workbook size (all)17-Jul-06556123Printout of each item from an Autofilter list (All)10-Feb-06394332Add pictures to a comment! (Excel 2000 >)26-Jan-06483919Excel 2003 Quick Reference Guide31-May-05423334Grouping Workbooks10-Nov-04412492Excel VB Constants (2003 and before)06-Oct-04394839Changing links to values (Excel 2000)13-Aug-04290455Systematic Approach to behavioral Problems in XL04-Sep-03244408Vlookup to the left? (Excel:97-2002)18-Jun-03231610AutoFilter and finding the last row (XL97 + Others?)04-Mar-03200526Distributing an Excel application with toolbars (5/95/97/2000/2002)25-Nov-02199037VBA StarPost Cross Reference (Excel 2K and Up)20-Nov-02186893Fixing Startup problems with Excel19-Nov-02118382Personal.xls Tutorial (All)20-Feb-0287625A new function: IFERROR()12-Nov-0168646All Excel shortcut keys01-Sep-0168243Useful Excel Customizations (Excel 2000/97)27-Aug-0151226Test format from All Caps to initial caps (O2k SR-1)03-Jul-0142335Different Page Layouts For Multi-page Worksheet30-May-0130606Removing External Links to another Workbook10-Apr-0123691Windows to Other Sheets15-Mar-0123508Windows to Other Sheets14-Mar-0121315A brief overview of Data Types07-Mar-01Frontpage / exp?ression Web 217511Repeat page within Navigation (Front Page 98/2000/XP)22-Mar-03214965Dynamic Site Map (All Versions)07-Feb-0399769form for viewers to email site to friends (FrontPage 2000)11-Dec-0161823Understanding Web Servers/Server Extensions and FP07-Aug-0152218FrontPage Express (FPE) (IE 5.5)07-Jul-0143726Word html in FP200006-Jun-0134352Submitting a Form & connecting to EMail24-Apr-01Internet Explorer 54652E-mail weblinks don't work (IE 5.00.3314)16-Jul-0152203FrontPage Express in IE5.5 (Internet Explorer 5.5)07-Jul-012535Removing Password from Content Advisor in IE21-Feb-011155Forcing View/Status Bar in IE21-Feb-01380Eliminate "URL-completion memory" in IE21-Feb-01Other Browsers and Email Clients 673007Searching a Firefox Bookmark List (Firefox)26-Oct-07631517Extracting images from a Web site (Firefox)23-Feb-07337538Emailing Not Using Outlook (Office 2003)02-Feb-04Outlook 443421Outlook Attachment Removal Manager (OL 2002 SP-2)06-Apr-0595584Temp file locations in Outlook (2000 and up)02-Feb-04334705Contacts (2002 sp2)23-Jan-04102995Sort Outlook Address Book (Outlook 2002)26-Dec-01Project 58165Using the Adjust Dates Macro26-Jul-01Powerpoint 389047Select Multiple Objects tool (PowerPoint 2000+)02-Apr-07583281Pick Up Object Formatting24-Nov-06246778Drawing multiple shapes (various Office applications)01-May-03235847Movies show as Blackboxes (2000)22-Mar-03226759Playing AVI movie clips (2002 with Win 2000)12-Mar-03199035VBA StarPost Cross Reference (PPT 2K and above)20-Nov-02123212Send to Word in B&W? (XP)12-Mar-02110572PowerPoint found an error that it can't correct04-Feb-0277929If your having trouble with sounds read this! (Power Point 2000)27-Sep-0138892BUILD15-May-0129724Hiding text in text box until clicked05-Apr-0128058Starting in Slide Show view20-Mar-0125223PowerPoint 2000 Initial Screen Layout20-Mar-01VBA 446450Dictionaries and Collectons (VBA)24-Oct-08618516Docking windows in the VBE (97, 2000, XP, 2003, 2007)25-Jan-07572453Overcome formfield length restriction (Word 97+)04-May-06380124Using .GIF and .JPG files to make Button Images23-Jun-05457801Iterating Word objects efficiently (Word VBA)03-Mar-05433911Converting Text to Proper Case08-Dec-04388906Mousewheel in IDE Update (VB 6, VBA 6.0)18-Jul-04228591Detecting email client (VB 6/Access 97)22-Mar-03219818Menu Bar Access Keys… Interesting Note (VB and IE)14-Feb-03196505Making toolbar visible depending on text selected? (Word 2002)19-Nov-02116277Retrieve Sender Address in Outlook (Outlook 2000)14-Feb-0219683Docking Floating Windows in VBE Editor02-Mar-01Word 729564Status Line (Word 2007)04-Oct-08731107Mailmerge Tutorial: Create Sorted Listings (2000-2007)08-Sep-08670027Relative Paths in Word Fields (All)18-Dec-07580610Nice Bullet Style (All)15-Jun-06565079Saving Your Place while scrolling (2000 and up)21-Mar-06492887Utility to edit tooltips of toolbar buttons30-Jun-05365442Word Field Maths (1.02)20-Mar-05421558Find/Replace Special Characters02-Nov-04409788How to keep a group of words on the same line (All)23-Sep-04387171Keyboard shortcuts for working with fields (All)29-Jul-04249902Date Calculations in Word17-Aug-04320421Field Codes-to-Text Converter (and vice versa)10-May-04339149Task Panes & Keep Track of Formatting (2002/2003)03-Feb-04273185Auto filling form fields - IF fields (Word 2K)11-Jul-03261488Update paths in INCLUDETEXT et al. (Word 2000/XP)05-Jun-03244732Autoshape Default23-Apr-03219116Reset 'Normal' double- click behavior for DOC files07-Feb-03207602How do i create a wizard that fills out a form.… (Word 2000)23-Jan-03203498Selectively disable menu option (Word 97/2000)18-Dec-02197827Systematic Approach to behavioral Problems in Word (97/2000)06-Dec-02203321Compatibility Options - Descriptions (Word 2000 SR3)05-Dec-021746012 printers, toolbar buttons? (Office 2000 SR2)04-Sep-02101097New on the Word MVP FAQ site - (all)05-Aug-02140440List Templates (Number- ing & Bullets) (Word 97/2000)26-Jul-025112Transferring Office settings to Another Machine24-Jul-02158329Field in Header (97)13-Jul-02135836Delete All Comments (2000)27-May-02106576Auto-update of Styles (97 SR-2)08-May-02127986Finding Command Names & Assigned Shortcut Keys30-Mar-02128577MailMerge from Excel (2000)28-Mar-02117390AutoExit vs. Application_Quit17-Feb-0288200Mail merge to table (Word 2000, SR1)01-Nov-0145313New on the Word MVP FAQ Page14-Oct-0176976Auto-numbering & Styles (Word 2000 SP-1)24-Sep-0119407Removing words from Dictionary09-Mar-0121373Creating your first Macro in Word08-Mar-011993Nice shortcut for entering text21-Feb-01