Open attachment, manipulate without add-on program?

Status
Not open for further replies.

Andrew Quirl

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Outlook.com (as MS Exchange)
Can all this be done with Outlook vba and/or Excel vba without installing an add-on program? If all of these steps cannot be accomplished, please specify which ones are the problem to facilitate my trip back to the drawing board.

1. recognize email source
2. open pdf attachment
3. select all
4. copy
5. open Excel
6. paste (dump) into A1
7. depending on the email source, save excel document .xlxs into a specified folder (outlook or a shared drive)
8. close the excel document (excel program can stay open or not)
9. close the pdf document
10. move the email into a specified folder in outlook
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
1. assuming source = email address, yes
2. yes
3. possibly. You'd need to open the pdf in word - if not, the pdf program needs to support vba (acrobat does but i don't know if it can do all that).
4. see 3
5. yes
6. yes
7. yes, as long as it's not too complicated. the fewer paths to store, the better.
8. yes
9. possibly.
10 yes
 

Andrew Quirl

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Outlook.com (as MS Exchange)
3. possibly. You'd need to open the pdf in word - if not, the pdf program needs to support vba (acrobat does but i don't know if it can do all that).
4. see 3

I only have the basic reader. Why Word? When I manually open the .pdf in Reader, keyboard CTRL+A/CTRL+C gets the data dump onto the clipboard.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can't control the pdf using vba - you can control word; acrobat supports VBA but i don't know the extent. (2013 and 2016 can open it, not sure about 2010. )

Without this support, you'd need to use send keys, which can be really clunky and buggy. Copying from word would be the easier. if the pdf is plain text, it should render ok in word - tables can be a problem though.
 

Andrew Quirl

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Outlook.com (as MS Exchange)
I'm not concerned about the table formatting loss. Are you saying Outlook vba can open the .pdf straight into Word instead of into Reader? Or open into Reader and then export to Word?
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
E Open olNoteItem Attachment Outlook VBA and Custom Forms 6
D Outlook VBA to open Excel attachment and send recipient's email address to a workbook cell? Using Outlook 4
S Pre populate subject + body + attachment to already open email in outlook 2007 Using Outlook 2
C How To Open Outlook Attachment in Excel, Modify some Data, then Re-Save It Using Outlook 3
S Cannot open any attachment from OWA Exchange Server Administration 2
C How to open .lnk attachment which is been blocked by outlook Using Outlook 3
J Everytime I receive and e-mail with a word attachment in it , when I open the attachment, it opens i Using Outlook 2
A Cant open email with macro in attachment Using Outlook 1
A Unable to open emails with Macros in attachment Using Outlook 4
D Need to open word attachment in 'print layout' view Using Outlook 1
M unable to open PDF or (http, www or utube) link attachment to outlook messages because of ' RESTRICT Using Outlook 1
A Cannot open attachment when opening Email. Using Outlook 1
A Cann't open one or more attachment Using Outlook 1
N File attachment open in a program. Using Outlook 1
D while opening an attachment (pictures) the pictures open using MS word Using Outlook 1
B can’t send attachments from the open file. Eg doing file – send to – mail recipient as attachment? - doesnt send Using Outlook 3
K word 2007 attachment won't open on windows 7 machine using Outlook Web Access v2003 Using Outlook 1
D The attachment filename.xls is open or in use by another application. Using Outlook 11
K Data files open in e-mail attachment form. How do I move these files into the data file location Using Outlook 1
C Unable to open attachment in OWA while same attachment can be open from Outlook Using Outlook 5
J Enable prompt to save/open attachment Using Outlook 1
B When I try to open a doc attachment it asked me to buy activate word and pay. Using Outlook 1
V ppt attachment slowly open or not responding in outlook 2007 Using Outlook 1
R Outlook infrequently crashes when trying to open any attachment Using Outlook 0
N CANNOT OPEN PREVIEW OF PDF ATTACHMENT IN OUTLOOK MAIL Using Outlook 14
V "A program has attachment filename open" Message returns Outlook VBA and Custom Forms 4
Y message attachment saved by Outlook.Attachment.SaveFileAs not open Outlook VBA and Custom Forms 7
T Unable to open attachment in Outlook 2003 Using Outlook 8
B Can't open or save a pdf attachment in outlook 2003 Using Outlook 56
L Cannot open PST file for first session each day Using Outlook 6
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 5
H Upon opening Outlook, make my popmail inbox open instead of outlook.com inbox Using Outlook 1
sahameed82 SharePoint calendar directly open in Outlook Using Outlook 0
N .pst archive from work will not open/import on Microsoft 365 Exchange Server Administration 0
C Outlook 2016/2019 hangs after being open for an extended period Using Outlook 4
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
W Automatically open attachments without automatically printing them Using Outlook 0
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
C Can't Open Outlook 365 Using Outlook 0
D after delete mail, open the next one Outlook VBA and Custom Forms 0
N VBA Script to Open highlighted e-mail and Edit Message Outlook VBA and Custom Forms 5
M outlook won't open! Using Outlook 1
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
E Unable to open Outlook 2010 after adding new email account Using Outlook 4
M other user's mailbox won't open, forms disappeared Using Outlook 42
S SendFromAccount - Problem trying to test existing value in open email Outlook VBA and Custom Forms 2
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
D Add Tetxbox at form open Outlook VBA and Custom Forms 1
U Catching ModuleSwitch events after "open in new window" Outlook VBA and Custom Forms 2
Similar threads


















































Top