+ Reply to Thread
Results 1 to 4 of 4

Formatting Email from Excel

  1. #1
    Registered User
    Join Date
    05-23-2018
    Location
    Texas, United States
    MS-Off Ver
    2013
    Posts
    39

    Formatting Email from Excel

    I am generating an email through outlook from VBA in excel. This email needs to have multiple pictures inserted with words intertwined between them, and while I have figured that part out, I can't figure out how to format the words. Here is an example of how I am editing the email.

    Please Login or Register  to view this content.
    How can I format the words "CUSHING" and any other words in the email?

    Thanks
    Last edited by jakegordon97; 02-10-2020 at 12:06 PM.

  2. #2
    Registered User
    Join Date
    05-23-2018
    Location
    Texas, United States
    MS-Off Ver
    2013
    Posts
    39

    Re: Formatting Email from Excel

    Or on a more simple level, how can I get Word VBA commands to all work in Excel VBA?
    I try to use the lines:

    Please Login or Register  to view this content.
    But, I get a "type mismatch" error when I add "WholeStory", which is a standard function in Word's VBA.
    Last edited by jakegordon97; 02-10-2020 at 10:34 AM.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Formatting Email from Excel

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

  4. #4
    Registered User
    Join Date
    05-23-2018
    Location
    Texas, United States
    MS-Off Ver
    2013
    Posts
    39

    Re: Formatting Email from Excel

    So I figured it out. Here's the code I used (Just change the End number to whatever takes up the whole email)

    Please Login or Register  to view this content.

+ 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] Email from Excel via VBA - Formatting problem
    By Msuliq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2017, 01:45 PM
  2. Sending Email with Email body in a cell keeping the formatting.
    By VBA_N_O_O_B in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2017, 11:35 PM
  3. [SOLVED] Creating email using Word document as email body – formatting lost
    By Chrispelletier in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-17-2016, 09:04 PM
  4. [SOLVED] Fonts and Formatting in Excel generated email
    By OAM in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-11-2013, 10:28 PM
  5. Create email using excel vba including formatting
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-15-2013, 10:16 AM
  6. [SOLVED] Why loss of excel formatting in email attachment on Win platform?
    By Steve Malicki in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 05:25 PM
  7. Formatting email and web addresses in Excel
    By JohnnyJomp in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-31-2006, 12:50 PM

Tags for this Thread

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