Author Topic: Send email with VBA  (Read 2999 times)

0 Members and 1 Guest are viewing this topic.

Adesu

  • Guest
Send email with VBA
« on: February 01, 2007, 01:48:45 AM »
Hi Alls,
I'm "NOT" expert in vba,very little understand about vba.
anyone have code in vba to send email,as figure I want that code display (not in dialog box) in command prompt,to ask to user first "send to" second "title the email" and then "body of email".
I very appreaciated for this help,thanks.

rkmcswain

  • Swamp Rat
  • Posts: 973
Re: Send email with VBA
« Reply #1 on: February 01, 2007, 08:07:38 AM »

Adesu

  • Guest
Re: Send email with VBA
« Reply #2 on: February 01, 2007, 07:56:18 PM »

Dnereb

  • Guest
Re: Send email with VBA
« Reply #3 on: February 12, 2007, 10:01:55 AM »
I know I've to disappoint you on the simplicity
but instead of using Outlook and Mapi, you can also use the CDO object(Late Bound) .
mail send through this object doesn't show any dialogs nor warnings (if the authorization is set correctly)
nor will the email show up in outlook or any other mail client.

I suggest You google around to find code samples on the CDO object.

Adesu

  • Guest
Re: Send email with VBA
« Reply #4 on: February 12, 2007, 07:17:44 PM »
Hi Dnereb,
Thanks for your suggest,I would to try it.

I know I've to disappoint you on the simplicity
but instead of using Outlook and Mapi, you can also use the CDO object(Late Bound) .
mail send through this object doesn't show any dialogs nor warnings (if the authorization is set correctly)
nor will the email show up in outlook or any other mail client.

I suggest You google around to find code samples on the CDO object.