A Macro for 'File - Save.As' on multiple selections

  • Thread starter Christopher Chambers
  • Start date
C

Christopher Chambers

I deal with well formatted emails by selecting them and using File - Save.As
to create a single text file.

Outlook (2003) concatenates the messages - I like that - I have to navigate
the filepath and name the file. I thought I'd automate those few keystrokes
to a single VBA macro. Simple as that sounds, I can find no way of
replicating the behaviour on *multiple* selections.

Sure I can iterate through the selections, save a temp file (with olTXT
etc.) then append the files in code to a single output but I feel I must be
missing something - am I?
 
S

Sue Mosher [MVP]

Maybe what you're missing is that Application.ActiveExplorer.Selection is a
collection containing the items the user has selected in the UI?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save a single worksheet to a different file using VBA 03 2
How to setup a list box with multiple selections 1
Print multiple selections to file by macro 2
passing a parameter based on multiple selections 7
Make Macro Work On A Different PC 5
Looking up a table value based on two conditional option buttons 2
Selecting multiple items on Listbox 2
Apply formula to a range with multiple selections 4

Top