here's what i am trying to do

[enoch5939]

I am sure that this has been covered, but whenever I try and search for something, I get a time out error, so I am sorry if this has been posted before.

I have found many many articles and references about what I am trying to do, but I guess I just can't seem to figure it out.

Here is what I am trying to do:

Column G is where I list emails. When I currently click on Column G it will open an outlook new mail message.

but there's nothing there, I have to add everything... What I am trying to figure out, is how to get populate 'other' cell information into the email, plus have a "default" message body all ready to go, so all i have to do is hit sent.

in the subject I want to populate columns c,d,e, with their corresponding Heading title in front of each of them.

In the body, I just need the Persons name from column b, and then the default message.

I really hope this makes sense. If anyone can help me, and explain to me in simple terms .. I would most appriciate it ...

James

 

[Oaktree]

See if my suggestion here starts you on the right path...

http://www.mrexcel.com/board2/viewtopic.php?t=236952

 

[enoch5939]

yeah, that didn't do anything for me ... sorry ...

 

[Norie]

James

What email client are you using?

If you are using Outlook this link might help Example Code for sending mail from Excel .

 

[Oaktree]

yeah, that didn't do anything for me ... sorry ...

What do you mean? You got an error (which one?) ? It isn't applicable to your problem? You're not using Outlook? You need it to do something it's not doing? You're not sure how to adjust the formula to your information? What is the exact formula you tried?

We need a little more to help you correct the issue you're having...

 

[enoch5939]

Well, first off, the link you sent me to, doesn't show "where" to put the code... do i put it in a cell... what do i do with it ... ??? I assumed I should copy and paste it to to a cell... but all it does it pastes the code and gets rid of my data ... is this code vba... ??? I dunno ...


Norie,

yes I have looked at and tried to make those work... but it all complicated and I just can't get it to work... I was hoping there was a simplar when to do it all...

 

[Norie]

I've not looked at the site for some time but as far as I can recall it's pretty straightforward.

What have you tried?

 

[enoch5939]

yes, i have tried a few different coding options on that site.

specifically these:

http://www.rondebruin.nl/mail/folder3/smallmessage.htm
http://www.rondebruin.nl/cdo.htm


and whatever I do, they don't seem to work...

 

[Norie]

How did you try them?

How didn't they work?

Do you have any code?

 

[enoch5939]

k, this is the code so far that i have... the parts that have my explaination in them are the parts that don't work ... I don't know how to reference the specific cells so that the information will appear in the apporiate field...
Do this help to explain???

Sub email()
'You must add a reference to the Microsoft outlook Library
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
strbody = "[This should reference the cell with the persons name] The column is B" & vbNewLine & vbNewLine & _
"message here"

With OutMail
.To = "this should be send to the address i click on in Column G"
.Subject = "Should reference Columns c, d, and e" I can add the headers for each of them "
.Body = strbody
.Display 'or use .Display
End With

Set OutMail = Nothing
Set OutApp = Nothing
End Sub