Copying to notepad

[joseoom]

I have the following question:

I want my code to copy a certain amount of information from excel, open a new notepad document and copy it there.

After that if possible save the notepad and attach it to an email.

I think that's impossible, but if someone can help I would greatly appreciate it.

Thanks!
Jose

 

[Norie]

Jose

Why not just create a text file?

I don't see any need to do this via Notepad, VBA has various file input/output methods.

As for the attachment part, the code for that would depend on your email client. eg Outlook, Lotus Notes etc

 

[joseoom]

you are absolutly right. I can save as a text file. But how do I do that?

To do the email part I use outlook.

 

[Norie]

Jose

The text part depends on what you actually want to do.

Do you want to create a text file based on a particular range?

For the email part try searching the forum for Outlook.

You'll find plenty of examples, most of which will deal with attaching workbooks/sheets but they will be easily adapt to work with a text file.

 

[joseoom]

Ok, half the work done I am left with one question.

I have managed to save as text. How can I name the file after a given cell.

Supose cell A1 says "Report 09-22" how can I make my txt file call that?