Consulting

Results 1 to 3 of 3

Thread: Solved: Prevent Excel Spreadsheet changed to Picture Format

  1. #1

    Solved: Prevent Excel Spreadsheet changed to Picture Format

    Hi There,

    I am trying to create an email template. The template will have the Excel Spreadsheet that is with Data Validation at cell A2 (pls refer to file attached). I managed to create the email template with the excel table. However the excel table will change to picture format once it is emailed. How to prevent this or rather any other better way to create this email template?

    tks!

  2. #2
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    Outlook version?

    If you need to have data validation on the worksheet, you're better off emailing it as an attachment. You can't embed it in an email and expect it to act like a worksheet.
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  3. #3
    noted & tks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •