+ Reply to Thread
Results 1 to 9 of 9

Modification in the Excel to Outlook mail

  1. #1
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Modification in the Excel to Outlook mail

    Hi All,

    I am using the attached macro to send excel sheet thru outlook mail body and am facing problem when the sheet is not exist.

    In the attached macro "Sheet 9" send to Mr.SSS([email protected]) is not available but it is pasting the previously copied "Sheet1" instead of not coping(should be blank).

    Kindly help to modify if the sheet is not exist it should not copy anything.

    Regards,

    Prabhu
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Modification in the Excel to Outlook mail

    You are taking from Sheet1 & Sheet2

    Please Login or Register  to view this content.
    thats why, dont understand what you're after are you after code to find if the sheet is there?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Modification in the Excel to Outlook mail

    Hi,

    My Query is if the sheet is not there in the workbook, it should not copy any sheet and it should go blank and continue for next command.

    Can you help hear.

    Regards,

    Prabhu

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Modification in the Excel to Outlook mail

    Ok, your post was really how to check a worksheet exists then.


    Please Login or Register  to view this content.


    Then you will have to do

    Please Login or Register  to view this content.
    =

  5. #5
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Modification in the Excel to Outlook mail

    Hi,

    I Copied the code to the excel. But it is only attaching the sheet but mail body is blank.

    Plz find the macro sheet for your reference.
    Attached Files Attached Files

  6. #6
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Modification in the Excel to Outlook mail

    Hi,

    Can you help on this

  7. #7
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Modification in the Excel to Outlook mail

    any update!

  8. #8
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    Re: Modification in the Excel to Outlook mail

    Copy to body of the mail (1).xlsm

    Hi

    Try now. Added a different HTML line

    Thanks

  9. #9
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Modification in the Excel to Outlook mail

    Hi,

    It is not running. I am getting error message as "BR" compile error variable not defined.

    Regards,

    Prabhu

+ 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. Replies: 2
    Last Post: 05-26-2014, 12:30 AM
  2. [SOLVED] Outlook Mail Automation Modification
    By Liz_Biz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-15-2014, 09:08 AM
  3. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM
  4. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  5. [SOLVED] e-mail from excel when outlook is not in use
    By Jignesh Khandwala in forum Excel General
    Replies: 5
    Last Post: 04-07-2006, 05:00 AM

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