+ Reply to Thread
Results 1 to 4 of 4

Export to email body each column is new row

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Export to email body each column is new row

    I am looking to export the following sheet to a email body (or even txt file) but the catch is I need each column to be a new line in the email with header

    Example of email body. Data from worksheet
    ENRN ENRN-000034
    Requestor DP
    Dept ENG
    ect.......


    So it would be 1 line for each column and also would have to do each row in worksheet.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Export to email body each column is new row

    Maybe using vbcrlf?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-14-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Export to email body each column is new row

    Thank You. I ran this and it is what i needed. Cannot believe I had such a brain fart that I couldn't get it. I was trying to hard to resolve the whole issue and not just parts at a time. When I am done the end result will be grabbing user selected rows, copying those rows to a temp sheet hiding 6 of 15 columns and then generating a email as mentioned above. The rest I am sure I can do but like I said for some reason the simple task I just could not remember how to do.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Export to email body each column is new row

    You're welcome. Glad to help out.

+ 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