VBA Code To Display Email Instead Of Automatically Send

[alulla]

I currently have a VBA code which selects a custom range and then emails said selected range to a list of E-mails I have in another worksheet. I've attached code, but this code is copied and pasted 8 times (there are 8 blocks)...Idk if that matters but just thought I should give as much information as possible. These are my two problems:

1) How to Display the email window on Outlook instead of automatically send (I've already tried .Item.Display and it does not work, so any alternatives or any other methods please recommend)
2) How to have the selected range keep its format (some of the text is red but once sent in an e-mail is displayed as default text).

Thanks in advance.

Please Login or Register  to view this content.

Link To OZGrid Post: http://www.ozgrid.com/forum/showthre...425#post671425

[HaHoBe]

Hi, alulla,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Ciao,
Holger

[alulla]

Ok, updated. Anyone have any advice?

[BigDawg15]

alulla,

Try .display instead of

.Item.Send

Regards,

BigDawg15

[alulla]

alulla,

Try .display instead of

.Item.Send

Regards,

BigDawg15

Hey, thank you for your reply!!!! Lol been refreshing this thread every few minutes in between my googling and nothing comes up so I was pretty excited to see you responded.

Anyway, as I said in my post I already tried .Display. If you take a look at my code where .Item.Send is, Item.Display SHOULD work...but it doesn't. that's why i made this post to see what the problem was, and what alternative method could be used to display the email before sending it.

[BigDawg15]

alulla,

For what its worth, I looked through several files I have, but none list the code with .item.display etc.
Everything I have uses the following:

Please Login or Register  to view this content.

Not saying yours is wrong, just stating what I use and see.

Sorry, I know that's not a big help!

BigDawg15