Results 1 to 5 of 5

Thread: How to embed Excel Workbook in Oultlook 2007 and edit Spreadsheet

  1. #1

    How to embed Excel Workbook in Oultlook 2007 and edit Spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    how would you embed an excel Workbook into an Outlook 2007 message where the workbook would be editable by the reciever and then the sender? I want to be able to send the spreadsheet back and forth and complete edits??

    Thanks
    ChrisO

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    I wouldn't.

    I'd resort to one of two options:
    1. I'd email the workbook as an attachement and ask them to send it to each person in order
    2. I'd try out Windows Live Skydrive, and share the workbook that way
    To be honst, I don't know if you can even embed an editable version of the workbook, but it sounds like a recipe for disaster if you could.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thank You
    I wanted to try to avoid the hole attaching thing and edit the spreadsheet in the email.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    You know, I think that there might be a way to deal with this using Windows Live Skydrive and Excel Webapp. If I'm right, what you'd need to do is:
    • Create a Windows Live (hotmail) account if you don't already have one
    • Go into the Skydrive portion and create a folder
    • Invite the people you want to be able to edit your document
    • After doing the above change the folder permissions to public (need to do this to share it out)
    • Upload your workbook to the folder
    • Get the embedding link (iFrame)
    • Create a full HTML email with the iFrame embedded
    What this would do is send a preview of the workbook in the email. By clicking the "edit" link, they should be taken to the webpage where they can edit the workbook on Skydrive. This way you'd only have one copy of the workbook, and every time they opened the email it would be up to date.

    The key issues are these:
    • WebApp doesn't render all Excel features
    • Some Excel features actually prevent workbooks from being opened in WebApp (data validation, macros, etc..)
    • The workbook must be shared in a public folder to do this. While uninvited users won't be able to edit, they could view it if they find the link
    • Creating a full html email in Outlook to make the iFrame link go live is awkward
    If it sounds like something that you'd like to puruse, let me know and I can work out the instructions for you.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    Argh... looked into this a bit more, and it appears that you can't embed an iFrame into an Outlook email. That is really unfortunate.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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