I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

See if this site helps.

http://www.rondebruin.nl/sendmail.htm

"Rpettis31" wrote:

I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

Two questions,
1.What line of code gets the sheet to go into the body of the email as I
keep sending a blank test email to my self?

2. How do I override the yes no cancel question that pops up with out look?

Thanks
Robert
S

"JLGWhiz" wrote:

See if this site helps.

http://www.rondebruin.nl/sendmail.htm

"Rpettis31" wrote:

I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

Have you test this one
http://www.rondebruin.nl/mail/folder2/mail4.htm

Maybe you like this one that filter for you and create the mails
http://www.rondebruin.nl/mail/folder3/row2.htm

See this page for the warning
http://www.rondebruin.nl/mail/prevent.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rpettis31" wrote in message ...
Two questions,
1.What line of code gets the sheet to go into the body of the email as I
keep sending a blank test email to my self?

2. How do I override the yes no cancel question that pops up with out look?

Thanks
Robert
S

"JLGWhiz" wrote:

See if this site helps.

http://www.rondebruin.nl/sendmail.htm

"Rpettis31" wrote:

I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

Dear Ron,

I need to let my user to send email automatically without any alert or
dialog display.

Please recommend VBA code to prevent displaying dialog to send or not send
when I put .send code insted of .display and Application.SendKeys "%S"
according to your recommendation on http://www.rondebruin.nl/mail/prevent.htm.

Thank you and regards,

Yongy

"Ron de Bruin" wrote:

Have you test this one
http://www.rondebruin.nl/mail/folder2/mail4.htm

Maybe you like this one that filter for you and create the mails
http://www.rondebruin.nl/mail/folder3/row2.htm

See this page for the warning
http://www.rondebruin.nl/mail/prevent.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rpettis31" wrote in message ...
Two questions,
1.What line of code gets the sheet to go into the body of the email as I
keep sending a blank test email to my self?

2. How do I override the yes no cancel question that pops up with out look?

Thanks
Robert
S

"JLGWhiz" wrote:

See if this site helps.

http://www.rondebruin.nl/sendmail.htm

"Rpettis31" wrote:

I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

If Sendkeys is not working

You can use the CDO code from my site or upgrade to Office 2007 (With Outlook)
But there is no good way for all systems that always work



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Yongy" wrote in message ...
Dear Ron,

I need to let my user to send email automatically without any alert or
dialog display.

Please recommend VBA code to prevent displaying dialog to send or not send
when I put .send code insted of .display and Application.SendKeys "%S"
according to your recommendation on http://www.rondebruin.nl/mail/prevent.htm.

Thank you and regards,

Yongy

"Ron de Bruin" wrote:

Have you test this one
http://www.rondebruin.nl/mail/folder2/mail4.htm

Maybe you like this one that filter for you and create the mails
http://www.rondebruin.nl/mail/folder3/row2.htm

See this page for the warning
http://www.rondebruin.nl/mail/prevent.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rpettis31" wrote in message ...
Two questions,
1.What line of code gets the sheet to go into the body of the email as I
keep sending a blank test email to my self?

2. How do I override the yes no cancel question that pops up with out look?

Thanks
Robert
S

"JLGWhiz" wrote:

See if this site helps.

http://www.rondebruin.nl/sendmail.htm

"Rpettis31" wrote:

I have an exception report by user that I generate. I can filter the list by
buyer but my question how can I paste that info into an email that goes
directly to the user?

The user code and the email abbrevation are the same so I believe I do not
have to put the full name @etc.com.

Is there are way to do this?

I haven't tried this yet, but you might try putting the "sending code"
into Outlook, then calling that sub from Excel. If it's in Outlook, it
should be trusted and the security prompt should be avoided.

HTH,
JP


On May 10, 2:15 am, Yongy wrote:
Dear Ron,

I need to let my user to send email automatically without any alert or
dialog display.

Please recommend VBA code to prevent displaying dialog to send or not send
when I put .send code insted of .display and Application.SendKeys "%S"
according to your recommendation onhttp://www.rondebruin.nl/mail/prevent.htm.

Thank you and regards,

Yongy