newb: Using VBA to open an excel attatchment

W

Whelan

Hello there,

New to VBA in Outlook, and have a quick question;

There are a number of emails that drop into a joint inbox in my department.
These emails contain excel attachments. I can write some VBA code to deal
with the attachment in excel, but would like to totally automate the process
by writing some VB in Outlook to open up the attachment based on the Email
Subject line??

Would be grateful for a few lines to get me started.

Thanks in advance

Whelan
 
J

Jonathan West

Hi Whelan

This group deals with VBA in Word.

For Excel VBA questions I would recommend trying
microsoft.public.excel.programming.

For Outlook VBA questions, try microsoft.public.outlook.program_vba

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 

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

VBA to Open Attatchments 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Macro: VBA code to move/forward email based on subjects and attachments 0
CTRL + END function to VBA - Inside an e-mail 0
Using Excel VBA: sending output data table to created .csv file + append 0
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
VBA Macro Training in Chennai 0
Using Excel VBA: sending output data table to created .csv file +append Options 1

Top