#1   Report Post  
Posted to microsoft.public.excel.newusers
Eef Eef is offline
external usenet poster
 
Posts: 2
Default sendmail

After having typed this code

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show(

I see a great number of arguments.
What do they stand for, or where could I find that?

Thanks in advance

--
Eef H.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 225
Default sendmail

Try searching in the HELP for VB Editor
You may look for 'Built-In Dialog Box Argument Lists'
Arguments are
recipients (string), subject (string), return_receipt (boolean)

Example:
Sub test()
send = Application.Dialogs(xlDialogSendMail).Show("abc@no where.com", "This
is a test mail", True)
End Sub

"Eef" wrote:

After having typed this code

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show(

I see a great number of arguments.
What do they stand for, or where could I find that?

Thanks in advance

--
Eef H.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,123
Default sendmail

Hi Eef

Why not use other mail code
You have much more options then

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



--

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




"Eef" wrote in message ...
After having typed this code

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show(

I see a great number of arguments.
What do they stand for, or where could I find that?

Thanks in advance

--
Eef H.



__________ Information from ESET Smart Security, version of virus signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com



  #4   Report Post  
Posted to microsoft.public.excel.newusers
Eef Eef is offline
external usenet poster
 
Posts: 2
Default sendmail

Ron,

Dank.
Duizelingwekkend wat er mogelijk is.

Eef H.

"Ron de Bruin" schreef in bericht
...
Hi Eef

Why not use other mail code
You have much more options then

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



--

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




"Eef" wrote in message
...
After having typed this code

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show(

I see a great number of arguments.
What do they stand for, or where could I find that?

Thanks in advance

--
Eef H. __________ Information from ESET Smart Security, version of virus
signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus
signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com





  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,123
Default sendmail

Graag gedaan

Suc6



--

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




"Eef" wrote in message ...
Ron,

Dank.
Duizelingwekkend wat er mogelijk is.

Eef H.

"Ron de Bruin" schreef in bericht
...
Hi Eef

Why not use other mail code
You have much more options then

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



--

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




"Eef" wrote in message
...
After having typed this code

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show(

I see a great number of arguments.
What do they stand for, or where could I find that?

Thanks in advance

--
Eef H. __________ Information from ESET Smart Security, version of virus
signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus
signature database 3954 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com






__________ Information from ESET Smart Security, version of virus signature database 3955 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3955 (20090323) __________

The message was checked by ESET Smart Security.

http://www.eset.com



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sendmail Mattlynn via OfficeKB.com Excel Discussion (Misc queries) 4 August 8th 08 12:21 PM
Branching Logic after SENDMAIL CPodd Excel Worksheet Functions 0 February 9th 07 04:36 PM
sendmail Noemi Excel Discussion (Misc queries) 0 February 10th 06 01:59 AM
Ron DeBruin's Sendmail Ken G. Excel Discussion (Misc queries) 1 October 18th 05 03:54 PM
SendMail Question Andy Tallent Excel Discussion (Misc queries) 8 May 19th 05 04:36 PM


All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"