Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2010, 02:45 PM
SilentLee SilentLee is offline Objective: Automatically export email text,attachment text to DB friendly format Windows 7 Objective: Automatically export email text,attachment text to DB friendly format Office 2007
Novice
Objective: Automatically export email text,attachment text to DB friendly format
 
Join Date: Nov 2010
Posts: 1
SilentLee is on a distinguished road
Default Objective: Automatically export email text,attachment text to DB friendly format

Hello,

These are the objectives I'm having difficulty achieving, and any assistance would substantially help bypass these roadblocks and be greatly appreciated.

Overall Objective: To create an email address which, upon a new email message, automatically processes the email. Processing includes opening email, copying text/printing email to pdf/exporting text to an "access friendly format", opening an attached word document (.doc)
, printing to pdf/exporting text to an "access friendly format" and a pdf file, copying text/exporting to an "access friendly format".

Manually, I've found that converting the email & attachments to pdf before copying text maintains the formatting which is critical to the documents maintaining their integrity. However it has become a requirement that this process be entirely automative so I think we can sacrafice some formatting at this point. Any suggestions regarding compatable formatting between programs would be greatly appreciated as well. When attempting to enable the add in to share data between access and outlook, I get the error message stating that the installation file is invalid/corrupt. I understand this is an outlook forum, so I shall refrain from any further Access related inquiries, but this roadblock has forced me to search for a work around.



For some reason my developer tab does not show up within Outlook. I've followed the steps suggested, and it does not work. I've found the VBA code for exporting email and attachments to excel, however I am unsure how to generate a macro from within Outlook. Is there a better way to do this that I have overlooked?

In my infinite wisdom, have failed to verify that this is possible. Can this be done?

I appreciate all feedback,

Thank you much
Lee

Note: I am beyond green regarding VBA script, Outlook in general, POP3/IMAP servers and so forth.
Reply With Quote
Reply

Tags
access, automate, export

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Objective: Automatically export email text,attachment text to DB friendly format Plain Text Email Reply in HTML format shamiar Outlook 1 07-29-2010 07:49 AM
Email (as Attachment) replaced by Mail Recipient (as Text) dcman7 Mail Merge 0 08-18-2009 08:08 AM
Automatically update text changes in Word - how do I do it? jonrm Word 2 05-21-2009 08:49 AM
format cells to automatically place quotes around text dirtleg Excel 1 09-16-2008 01:52 PM
text disappears with attachment randy Outlook 0 07-18-2007 11:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft