+ Reply to Thread
Results 1 to 3 of 3

Macro help for emailing objects not just cells using outlook

  1. #1
    Registered User
    Join Date
    05-12-2011
    Location
    NJ
    MS-Off Ver
    Excel 2003
    Posts
    10

    Macro help for emailing objects not just cells using outlook

    Hi i am trying to finish a macro to send out an email to every person on a list with a chart and info that is dependent on the person. the macro is as follows: (please check post 2 for the problem)

    Please Login or Register  to view this content.
    Last edited by nvidiaev; 05-18-2011 at 09:13 AM.

  2. #2
    Registered User
    Join Date
    05-12-2011
    Location
    NJ
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Help with Macro

    This works properly with the exseption of shapes. i have tried to add the copy to the temp book of all the shapes but its not working out. I dont know VBA but i am somewhat capable to read it and change things around most of this macro was created via {record} and sripts i have found on this and other forums that i put togather, i know its not the best way but it has gotten me by so far.

    i have bolded the script to paste theshapes as well as the cells that i have tried to write below that ends up stoping this macro from working


    .Shapes.Range(Array("Picture 10", "Text Box 8", "Picture 9", "Picture 6", "Chart 5")).PasteSpecial Paste:=8
    .Shapes.Range(Array("Picture 10", "Text Box 8", "Picture 9", "Picture 6", "Chart 5")).PasteSpecial xlPasteValues, , False, False
    .Shapes.Range(Array("Picture 10", "Text Box 8", "Picture 9", "Picture 6", "Chart 5")).PasteSpecial xlPasteFormats, , False, False
    .Shapes.Range(Array("Picture 10", "Text Box 8", "Picture 9", "Picture 6", "Chart 5")).Select
    Application.CutCopyMode = False


    Please Login or Register  to view this content.
    if anyone could help me fix this that would be great, thanks in advance.
    Last edited by nvidiaev; 05-17-2011 at 04:29 PM.

  3. #3
    Registered User
    Join Date
    05-12-2011
    Location
    NJ
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Macro help for emailing objects not just cells using outlook

    could anyone give me a better script for this:

    Please Login or Register  to view this content.
    so that it dosnt just pick up cells but objects as well?
    the objects that are needed to be inserted are as follows

    "Picture 10", "Text Box 8", "Picture 9", "Picture 6", "Chart 5"

    the cell area is from A1:J34

+ 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