send temporary data without saving the workbook
 

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

send temporary data without saving the workbook
 

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

send temporary data without saving the workbook
 

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