e-mail the entry data

[FSalgueiro]

I have a spreadsheet that needs to be send all the data enter into a text format for a specific e-mail but have to be according to K13 information something like if K13 show Mr. Sample the e-mail goes to [email protected] K13 shows mrssample2 the e-mail goes to [email protected] and I don’t know how to make this macro any help?

[blue.chio]

perhaps something like this

Please Login or Register  to view this content.

or see here http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[FSalgueiro]

It worked thanks, is there any way that I populate a porting of the "TO"with the email address in K12 and send the e-mail automatically.

[blue.chio]

try this

Please Login or Register  to view this content.

[FSalgueiro]

Thank you a lot

[blue.chio]

Glad it helped you. Thank you for the feedback!

[FSalgueiro]

Sorry, but can I ask you another question is there any way a save the data in a temp file and upload the file every time that macro it’s run?

[blue.chio]

perhaps you are thinking at the save/kill processes, I am sorry, I have no idea...