Copying text

Mavspeed

New Member
Joined
Jul 20, 2006
Messages
13
Hi all,

1. How can I copy text from txt file into txtbox on userform, i.e. let say taht there is a txt file on c:\ containing some text in few lines and I would like to copy all into one txt box??

2. I have a code in vba that I'm using to send mail'e directly from excel but I don't know is it possible and if yes how can I put signature from outlook into this message.

Regards,
Mav
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good morning Mavspeed

(1) There was quite a discussion about this fairly recently - the bottom line is that it can be done in one of several ways :

http://www.mrexcel.com/board2/viewtopic.php?t=220912

(2) It is possible to send a mail from within Excel, and it is possible to pull your signature and use that. As you're using Outlook, Ron de Bruins site has tons of examples and stuff.

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

If you're not that well up on writing code you may be better off with his free SendMail add-in.

http://www.rondebruin.nl/mail/add-in.htm

HTH

DominicB
 

Forum statistics

Threads
1,141,728
Messages
5,708,130
Members
421,548
Latest member
douae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top