A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sendmail



 
 
Thread Tools Display Modes
  #1  
Old March 23rd, 2009, 12:12 PM posted to microsoft.public.excel.newusers
Eef
external usenet poster
 
Posts: 15
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  
Old March 23rd, 2009, 02:44 PM posted to microsoft.public.excel.newusers
Sheeloo[_4_]
external usenet poster
 
Posts: 204
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  
Old March 23rd, 2009, 04:07 PM posted to microsoft.public.excel.newusers
Ron de Bruin
external usenet poster
 
Posts: 2,861
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  
Old March 23rd, 2009, 05:48 PM posted to microsoft.public.excel.newusers
Eef
external usenet poster
 
Posts: 15
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  
Old March 23rd, 2009, 05:55 PM posted to microsoft.public.excel.newusers
Ron de Bruin
external usenet poster
 
Posts: 2,861
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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.