+ Reply to Thread
Results 1 to 3 of 3

Easy-write a <return> in text in a macro

Hybrid View

cheddarthief Easy-write a <return> in text... 04-12-2010, 02:34 PM
mdbct Re: Easy-write a <return> in... 04-12-2010, 03:02 PM
cheddarthief Re: Easy-write a <return> in... 04-12-2010, 03:55 PM
  1. #1
    Forum Contributor
    Join Date
    02-20-2010
    Location
    Youngstown, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    182

    Easy-write a <return> in text in a macro

    I have a macro I found that works great and at one point there is a reference to the body of an email and in that body it writes the following automatically: "Please see the attached RFQ." using the following code:

    TextMsg = "Please see the attached RFQ."
    I want the text to come out as:

    Please see the attached quote.

    <my name here>

    So to do this, I'll need to drop down two lines at the end of the sentence. How do I do that?

    Jim
    Last edited by cheddarthief; 04-12-2010 at 03:56 PM. Reason: Solved

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: Easy-write a <return> in text in a macro

    TextMsg = "Please see the attached RFQ." & vbLf  & vbLf & "<yourname here>"

  3. #3
    Forum Contributor
    Join Date
    02-20-2010
    Location
    Youngstown, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    182

    Re: Easy-write a <return> in text in a macro

    Worked perfect. Figured it was easy for someone whose not a newbie such as myself. Thanks a ton.

    Jim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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