Hi all,

Users in different locations use a vba userform.
data from the form are loaded to a workbook template which is saved with a new name and then sent to a central.

I also want a small extraction of the data sent to me. However, as the filing system will be different at each pc, i don't want the user to look for a file where the extracted data are stored. I want my data copies and pasted to a new workbook and then send the workbook (without saving it).

So far I have recorded the following:

Sub copytonew()

Selection.CurrentRegion.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste

Application.Dialogs(xlDialogSendMail).Show

End Sub

Everything I do in sendmail-dailog is not recorded!

So, my question comes down to:

What are the possibilities of xlDialogSendMail ?
Is the xlDialogSendmail restricted to special Excel versions?

any help is greatly appriciated,

Thanks in Advance

Sybolt

Op donderdag 23 juli 2015 11:21:53 UTC+2 schreef Roady Mayhem:
Hi all,

Users in different locations use a vba userform.
data from the form are loaded to a workbook template which is saved with a new name and then sent to a central.

I also want a small extraction of the data sent to me. However, as the filing system will be different at each pc, i don't want the user to look for a file where the extracted data are stored. I want my data copies and pasted to a new workbook and then send the workbook (without saving it).

So far I have recorded the following:

Sub copytonew()

Selection.CurrentRegion.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste

Application.Dialogs(xlDialogSendMail).Show

End Sub

Everything I do in sendmail-dailog is not recorded!

So, my question comes down to:

What are the possibilities of xlDialogSendMail ?
Is the xlDialogSendmail restricted to special Excel versions?

any help is greatly appriciated,

Thanks in Advance

Sybolt

Hi, again,

I have found the three arguments that you can use in the xldialogsendmail.
One question i have left is: Can you force the sending of the mail without clicking on the 'Send' button in the mail window?

Thanks,

Sybolt

Hi,

Am Thu, 23 Jul 2015 04:52:46 -0700 (PDT) schrieb Roady Mayhem:

I have found the three arguments that you can use in the xldialogsendmail.
One question i have left is: Can you force the sending of the mail without clicking on the 'Send' button in the mail window?

please have a look:
http://www.rondebruin.nl/win/section1.htm


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional