+ Reply to Thread
Results 1 to 2 of 2

Populate the subject line.

  1. #1
    Scott Hutchinson
    Guest

    Populate the subject line.

    I'm completly new to excel and am using 2002. I've fumbled my way through
    getting a button added to my spreadsheet to automatically send an email to a
    particular person when pressed. What I would like to do now is insert into
    the email subject line the contents of a cell PLUS additional text.
    So if Cell A2 contains 'AAA' (cell one has my button occupying it now) then
    I would want the subject line to be something like this 'AAA Finalized
    Spreadsheet'

    How would one go about doing this?

    Also perhaps a seperate subject but this spreadsheet has Letters in column 1
    from AAA to ZZZ, each letter represents a location. Is there a way for me to
    automate creating mulitple worksheets for each of these locations or rather
    FILES. (aaa.xls, bbb.xls) yet each file ONLY contain the data where column 1
    is = to aaa or so on? (I'd hate to cut and paste all this!) Also would be
    nice if the button would goto each of these 'new' files as well
    automatically, including page protections.

    Thanks in advance for any help!!!

  2. #2
    James
    Guest

    Re: Populate the subject line.

    I use the following code to automatically send an email attaching the active
    spreadsheet

    ActiveWorkbook.HasRoutingSlip = True
    With ActiveWorkbook.RoutingSlip
    .Delivery = xlAllAtOnce
    .Recipients = Array("Name of recipient")
    .Subject = "Enter message subject "
    .Message = "Main Message"
    .ReturnWhenDone = False
    End With
    ActiveWorkbook.Route

    James


    "Scott Hutchinson" <Scott Hutchinson@discussions.microsoft.com> wrote in
    message news:EE761790-7E58-43CC-B94E-C82AFAF56823@microsoft.com...
    > I'm completly new to excel and am using 2002. I've fumbled my way through
    > getting a button added to my spreadsheet to automatically send an email to
    > a
    > particular person when pressed. What I would like to do now is insert into
    > the email subject line the contents of a cell PLUS additional text.
    > So if Cell A2 contains 'AAA' (cell one has my button occupying it now)
    > then
    > I would want the subject line to be something like this 'AAA Finalized
    > Spreadsheet'
    >
    > How would one go about doing this?
    >
    > Also perhaps a seperate subject but this spreadsheet has Letters in column
    > 1
    > from AAA to ZZZ, each letter represents a location. Is there a way for me
    > to
    > automate creating mulitple worksheets for each of these locations or
    > rather
    > FILES. (aaa.xls, bbb.xls) yet each file ONLY contain the data where column
    > 1
    > is = to aaa or so on? (I'd hate to cut and paste all this!) Also would be
    > nice if the button would goto each of these 'new' files as well
    > automatically, including page protections.
    >
    > Thanks in advance for any help!!!




+ 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