Insurance_Guy
New Member
- Joined
- Jul 22, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello! After cobbling together bits and pieces from this and other forums, I now have a beautiful VBA Macro that opens a new Outlook email and pastes custom text into the body of the email. It works great, but there is one feature I want to include that I need which I just can't crack.
What I would like to do is add a step in my macro to find and select a specific phrase found with the text of the email that I've just created and then paste (.PasteSpecial-as-picture?) the image of some client-specific cells that have already been copied into the MS Office clipboard. For example, in the sample email text below I'd like the macro to find/select the phrase '[INSERT IMAGE 1 HERE]' and paste special > as picture an image of a graph that was created for this client for this email:
Dear Client,
This is the intro text to you, my valued client, and here is an image of the graph that I would like you to check out below:
[INSERT IMAGE 1 HERE]
This is the text where I tell you to let me know if you have any questions.
Sincerely,
Does anybody a lot smarter than me have any suggestions for how this would be accomplished? Or if not, is there a smarter/easier way to do this than through find/replace (which is the solution that makes the most sense to me)? I feel like this shouldn't be very difficult, but even so I can't figure it out.
Thanks in advance!
What I would like to do is add a step in my macro to find and select a specific phrase found with the text of the email that I've just created and then paste (.PasteSpecial-as-picture?) the image of some client-specific cells that have already been copied into the MS Office clipboard. For example, in the sample email text below I'd like the macro to find/select the phrase '[INSERT IMAGE 1 HERE]' and paste special > as picture an image of a graph that was created for this client for this email:
Dear Client,
This is the intro text to you, my valued client, and here is an image of the graph that I would like you to check out below:
[INSERT IMAGE 1 HERE]
This is the text where I tell you to let me know if you have any questions.
Sincerely,
Does anybody a lot smarter than me have any suggestions for how this would be accomplished? Or if not, is there a smarter/easier way to do this than through find/replace (which is the solution that makes the most sense to me)? I feel like this shouldn't be very difficult, but even so I can't figure it out.
Thanks in advance!