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

  • Thread starter Q2hyaXN0b3BoZXIgQ2hhbWJlcnM
  • Start date
Status
Not open for further replies.
Q

Q2hyaXN0b3BoZXIgQ2hhbWJlcnM

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?

Sue Mosher

"Christopher Chambers" <Christopher Chambers
wrote in message news:1A6019BF-C2A2-4E76-AE4C-70B78DC9EC88@microsoft.com...
> 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?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Matt Johnson Save File Macro Working Sporadically Using Outlook 9
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
P Macro to attach a file in a shared Outlook draft folder Outlook VBA and Custom Forms 2
R Macro to check file name with outlook address book Outlook VBA and Custom Forms 0
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
H Macro to file Outlook email by sender's email address Using Outlook 11
C Help with a Macro to move emails to a different PST data file Using Outlook 4
E Macro to export BCM business data to CSV file BCM (Business Contact Manager) 1
W Macro to File Inbox Messages? Using Outlook 1
B Simple way to insert file text - macro? Outlook VBA and Custom Forms 1
J Macro to create folder in PST file Outlook VBA and Custom Forms 4
V Macro to count flagged messages? Using Outlook 2
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Macro to block senders domain Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
D Autosort macro for items in a view Outlook VBA and Custom Forms 2
S HTML to Plain Text Macro - Help Outlook VBA and Custom Forms 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
S Visual indicator of a certain property or to show a macro toggle Outlook VBA and Custom Forms 2
L Modifying VBA script to delay running macro Outlook VBA and Custom Forms 3
S Macro to extract and modify links from emails Outlook VBA and Custom Forms 3
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
S Macro for Loop through outlook unread emails Outlook VBA and Custom Forms 2
Globalforester ItemAdd Macro - multiple emails Outlook VBA and Custom Forms 3
S Macro to extract email addresses of recipients in current drafted email and put into clipboard Outlook VBA and Custom Forms 2
witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
witzker Macro to move @domain.xx of a Spammail to Blacklist in Outlook 2019 Outlook VBA and Custom Forms 7
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 4
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
V macro runs slower on startup than after Outlook VBA and Custom Forms 3
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1

Similar threads

Top