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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
 
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

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
Back
Top