Hi there,
Relatively new to VBA so this is proving quite a challenge for me.
Does anyone have a simple VBA code to Copy a cell (in this case A111), open Outlook, paste the cell contents into the body of the email and add an email address and subject?
I have found a code that seems to open the workbook into an email format, but is within excel. I need this to paste the data into an outlook email.
Any help would be greatly appreciated!
Thank you
what exactly is in cell A111?
is the body of the email pre existing or you creating a new email from scratch?
sounds like you need something like this
https://www.rondebruin.nl/win/s1/outlook/bmail2.htm
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hmmm Apologies if this duplicates the reply... seems my reply did not save.
Cell A111 has a concatenate formula stringing an array of cells together. The link you have posted does work for the most part, but for some reason not pasting the data into the email body.
I think it has something to do with setting the range (set rng) but this is a bit beyond my skills to fix.
Here's what I have so far:
Please Login or Register to view this content.
hmm just try this instead
you dont need to use HTMLbody if you just want to paste text from a cellPlease Login or Register to view this content.
go with the .body and then you can get rid of all that other stuff to do with RNG as well
the full code was designed to do much broader stuff than it seems like you don't require
Last edited by humdingaling; 12-18-2017 at 02:32 AM. Reason: simplified outcome
Perfect!! Thank you SOOOOOO much! That works a treat!!
Last edited by CheekyDevil; 12-18-2017 at 02:35 AM.
sorry
did you read my amended post or first post?
i jumped the gun and may have over complicated it with my original post
Haha yep delays are a pain huh
sometimes i reply too fast before reading the whole responses
Not a problem
Glad to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks