+ Reply to Thread
Results 1 to 3 of 3

Create mail with body from clipboard

  1. #1
    Forum Contributor
    Join Date
    01-26-2005
    Posts
    108

    Create mail with body from clipboard

    I want to use a macro to create a mail that contains an image of any cells selected when the macro is triggered.

    Creating the mail is not a problem for me.
    Using "copypicture" to place an image of the selected cells onto the clipboard is not a problem.

    The problem is getting that image from the clipboard into the mail.

    Any ideas?
    Thanks in advance.
    Tony

  2. #2
    Forum Contributor Tarball's Avatar
    Join Date
    04-21-2007
    Location
    Atlanta, GA
    Posts
    166
    I would save the image from the Clipboard to a file on the users PC and then I would attach it to the email. I would do this because not everyone uses HTML as their default message type so the image would be lost in the email,BMP images can contain embedded viruses and as such many email systems now flag them and strip them out.
    Reach me at excel_help at bellsouth dot net

  3. #3
    Forum Contributor
    Join Date
    01-26-2005
    Posts
    108
    Makes sense (thanks), can anyone help as to what I need to do to achieve this?

+ 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. Create new workbooks and worksheets from an existing Workbook
    By nazmul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2008, 11:07 PM
  2. Create a mail using the mailto: function
    By Dynelor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2008, 07:28 PM
  3. Formatting E Mail Body Text
    By jagstirling in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2008, 10:10 PM
  4. Using mail merge to create sorted list in word
    By jkanclerz in forum Excel General
    Replies: 0
    Last Post: 11-28-2007, 02:47 PM
  5. Zip File And Mail With Lotus Notes
    By mridzuan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2007, 02:22 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