Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i email the contents of a userform?
HI There,
I am using winXP pro with Office 2003 Pro I have a userform, 'QForm', that is programmed to show data from a spreadsheet (costsheet) in all the relevant text boxes or labels. The contents form the basis of a Quote for supplying goods. A lot of my clients are now asking that I email them the quote, which I do by printing off, scanning in and then sending as an attachment. What I'd like to be able to do is to insert the data, either as an image or as text into the body of an email. Is this possible to do? Obviously I would need to keep the format of the form. I appreciate any and all help. Regards Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i email the contents of a userform?
I suggest Ron Debruin's example code:
http://www.rondebruin.nl/mail/folder3/smallmessage.htm Regards, Greg "Richard" wrote: HI There, I am using winXP pro with Office 2003 Pro I have a userform, 'QForm', that is programmed to show data from a spreadsheet (costsheet) in all the relevant text boxes or labels. The contents form the basis of a Quote for supplying goods. A lot of my clients are now asking that I email them the quote, which I do by printing off, scanning in and then sending as an attachment. What I'd like to be able to do is to insert the data, either as an image or as text into the body of an email. Is this possible to do? Obviously I would need to keep the format of the form. I appreciate any and all help. Regards Richard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i email the contents of a userform?
I had a look at that, but I can't see a way to copy the data from the
userform controls (text boxes and labels) "Greg Wilson" wrote in message ... I suggest Ron Debruin's example code: http://www.rondebruin.nl/mail/folder3/smallmessage.htm Regards, Greg "Richard" wrote: HI There, I am using winXP pro with Office 2003 Pro I have a userform, 'QForm', that is programmed to show data from a spreadsheet (costsheet) in all the relevant text boxes or labels. The contents form the basis of a Quote for supplying goods. A lot of my clients are now asking that I email them the quote, which I do by printing off, scanning in and then sending as an attachment. What I'd like to be able to do is to insert the data, either as an image or as text into the body of an email. Is this possible to do? Obviously I would need to keep the format of the form. I appreciate any and all help. Regards Richard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i email the contents of a userform?
The "strbody" string variable holds the text you want to send. I don't know
how you want to arrange the data but this is an example: strbody = TextBox1.Text & vbCr & _ Label1.Caption & vbCr & _ TextBox2.Text & vbCr & Label2.Caption With OutMail .To = " .CC = "" .BCC = "" .Subject = "This is the Subject line" .Body = strbody 'Above concatenated text is send as email body .Send 'or use .Display End With "Richard" wrote: I had a look at that, but I can't see a way to copy the data from the userform controls (text boxes and labels) "Greg Wilson" wrote in message ... I suggest Ron Debruin's example code: http://www.rondebruin.nl/mail/folder3/smallmessage.htm Regards, Greg "Richard" wrote: HI There, I am using winXP pro with Office 2003 Pro I have a userform, 'QForm', that is programmed to show data from a spreadsheet (costsheet) in all the relevant text boxes or labels. The contents form the basis of a Quote for supplying goods. A lot of my clients are now asking that I email them the quote, which I do by printing off, scanning in and then sending as an attachment. What I'd like to be able to do is to insert the data, either as an image or as text into the body of an email. Is this possible to do? Obviously I would need to keep the format of the form. I appreciate any and all help. Regards Richard |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i email the contents of a userform?
Thanks Greg, I now understand what it's all about.
What I guess I was looking for was a right click and a 'send to' option that would allow me to send to a 'mail recipient' and it would literally copy the form to the 'strbody'. The only thing that comes close is the screen capture, but it only gets the top of the form. Is there any way that the form height and width parameters can be included in the screen capture? Thanks again Richard "Greg Wilson" wrote in message ... The "strbody" string variable holds the text you want to send. I don't know how you want to arrange the data but this is an example: strbody = TextBox1.Text & vbCr & _ Label1.Caption & vbCr & _ TextBox2.Text & vbCr & Label2.Caption With OutMail .To = " .CC = "" .BCC = "" .Subject = "This is the Subject line" .Body = strbody 'Above concatenated text is send as email body .Send 'or use .Display End With "Richard" wrote: I had a look at that, but I can't see a way to copy the data from the userform controls (text boxes and labels) "Greg Wilson" wrote in message ... I suggest Ron Debruin's example code: http://www.rondebruin.nl/mail/folder3/smallmessage.htm Regards, Greg "Richard" wrote: HI There, I am using winXP pro with Office 2003 Pro I have a userform, 'QForm', that is programmed to show data from a spreadsheet (costsheet) in all the relevant text boxes or labels. The contents form the basis of a Quote for supplying goods. A lot of my clients are now asking that I email them the quote, which I do by printing off, scanning in and then sending as an attachment. What I'd like to be able to do is to insert the data, either as an image or as text into the body of an email. Is this possible to do? Obviously I would need to keep the format of the form. I appreciate any and all help. Regards Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Contents on UserForm | Excel Programming | |||
Email Userform | Excel Discussion (Misc queries) | |||
userform txt box contents | Excel Discussion (Misc queries) | |||
Email a Userform | Excel Programming | |||
Email Range Contents | Excel Programming |