Subject: Tech Primer on using MS Access to Send Email By Pete Bennett htpp://pcbenett.blogspot.com Posted: 04/23/2013 11:29:43 AM PDT Updated: 04/23/2013 02:16:02 PM PDT Location: Walnut Creek CA
Tuesday, April 23, 2013
VBA Tech Primer on using MS Access to Send Email
VBA - Visual Basic for Applications - Scripting, ASP, MS Office Automation
VBA - Visual Basic for Applications -
VBA has been around for over 20 years. In the early days it was a limited to core functions supporting MS Access, Excel, Word and Windows Server functions such as login scripts. The early days of DOS were used to manage logins to Novell Servers which was the impossible to catch leader for nearly a decade.
Scripting,
Active Server Pages (ASP)
Developed by Microsoft in mid nineties as their foray so the Windows NT Servers could be sold as supporting web sites. The IIS model 5.0 was pretty crude compared to current standards but then few hardly cared about online attacks such as the NIMBA virus.
MS Office Automation
This is where MS Access can take over MS Outlook or send data to MS Word to Publish a mailing list or mailmerge.
VBA has been around for over 20 years. In the early days it was a limited to core functions supporting MS Access, Excel, Word and Windows Server functions such as login scripts. The early days of DOS were used to manage logins to Novell Servers which was the impossible to catch leader for nearly a decade.
Scripting,
Active Server Pages (ASP)
Developed by Microsoft in mid nineties as their foray so the Windows NT Servers could be sold as supporting web sites. The IIS model 5.0 was pretty crude compared to current standards but then few hardly cared about online attacks such as the NIMBA virus.
MS Office Automation
This is where MS Access can take over MS Outlook or send data to MS Word to Publish a mailing list or mailmerge.
Sunday, April 14, 2013
Craigslist Ad 101 Oakland Downtown
Great Rates
/ Fast Service / Over 20 years direct client consulting / ASP.NET Experts
Hard Technical:
- ASP.NET, VB.NET, C# and SQL Server Development
- Windows Web Development using Visual Studio 2010
- Expert level with XML and XSLT
- Comfortable with using .NET library with XML
- Intermediate level with XML and XSLT
- Thorough understanding of core ASP.NET
- Object models, data model, and web service design
- Entity Framework, LINQ, Strong Data Patterns
- Siilverlight, AJAX, JavaScript, Jquery
MS Office Skills - Expert Level
- MS Access Databases from cradle to grave
- MS Access Developer
- MS Outlook - Custom Add-ins, Custom VBA Scripting
- MS Publisher
- MS Word Integration using RTF to create complex data driven forms
- MS PowerPoint - complex business driven presentations
- MS Excel - functions, formulas and data access
Consulting Services
- Business Development
- CRM Systems and Selections
- Legal and Business Strategies
- Business Process Development
- Internal Forms Development
- Business Inteligence
Qualifications:
- Over 20 years of software development
- Over 30 years of business acumen
- Strong Legal Background - thorough understanding of tort and contract law
- Strong analytical capabilities
- Passionate commitment to engineering quality and productivity
- Self Regulated, Self Directed and Self Taught
- More
Other Technical Skills
- Code/Logic
- User Interface
- Reporting
- Security/Authentication
- Application
Utilizing the latest Microsoft Tools/Architecture
- Microsoft Web Applications and Services
- Microsoft SQL Server Database Applications
- Microsoft Windows Applications Microsoft Azure Cloud Applications Mobile Applications
Industries Served
- Banking, Mortgage, And Finance
- Real Estate, Real Estate Firms and Mortgage Operations
- Construction, Construction Manangement
- High Tech, Software and Hardware Companies
- Medical, Hospital, Records Management
- Manufacturing, ERP, MRP
- Small Business Enterprise
What you need to know about Pete Bennett :d to know about Pete Bennett :
- Has appeared on CNN, ABC and Wall Street Journal
- Speaker and pPesenter
- Seasoned Musician and Performer
- Worked at Fortune 10 Companies
| DDD |
|---|
| Amtrak Stops Stop Here and There Traveling Amtrak and enjoy working via Wifi |
| Azure Experts Expert Advice and Articles on Azure (SQL Cloud) |
| Azure Expert We're Microsoft Developers and prefer Azure |
| Azure Expert We're Microsoft Developers and prefer Azure |
| Bay Area Open Mics bayareajam |
| Bay Area Sightseeing Sharing 35 years of destinations |
| Email Market Directory - Resource Locator Bay Area Sightseeing |
| Bay Area Sightseeing Localized, Accurate and Full of Fun |
| Bay Area Surplus Someone wants to get rid of something everyday |
| Casino Vacation Reports This will be fun covering CA, NV, WA and OR |
| Cell Phone Index We've got the contacts for inside information |
Craiglist.com Contact Us Page
Welcome from Craigslist.com
You've landed on Pete Bennett blog created specifically for visitors coming from Craig's site. This page is part filter and partly a welcome page.
The filter is on for the same it's getting harder and harder to post on Craigslist due the the endless spammers who use all sorts of tricks.
You've landed on Pete Bennett blog created specifically for visitors coming from Craig's site. This page is part filter and partly a welcome page.
The filter is on for the same it's getting harder and harder to post on Craigslist due the the endless spammers who use all sorts of tricks.
Craigslist Ad #100
Microsoft Developer and Blogger (financial district)
|
Customer Solutions - Outlook Automation
Customer Solution:
Developed custom connectors by integrating VBA, MS Access, VB, with Outlook VBA that processed zipped files that arrived as attachments for daily reports, files and datasets. The MS Access program monitored Outlook via the library, then processed the attachments by unzipping, reading the files, parsing the headers then reformatted the data for Yardi Systems General Ledger property management module.
The client was consuming several hours per day for a daily task that was very tedious that few in the offices wanted to deal with. The net savings in man hours was about 16 to 20 hours per week or the equivalent of part time employee's salary.
Net savings in a professional office was significant enough to justify project.
Payroll Savings: $15,000
Project Cost: $4,000
Computer Programmer
Walnut Creek Company
April 2007 - August 2010 -
Walnut Creek, CA
Developed custom applications are requested using Outlook,
Access and VB - Contract work at random times over 5 years
Skills: ASP, Outlook, VBA, Web
HTML, ETL, SQL Server 7/2000/2005, Microsoft Word 2003
Developed custom connectors by integrating VBA, MS Access, VB, with Outlook VBA that processed zipped files that arrived as attachments for daily reports, files and datasets. The MS Access program monitored Outlook via the library, then processed the attachments by unzipping, reading the files, parsing the headers then reformatted the data for Yardi Systems General Ledger property management module.
The client was consuming several hours per day for a daily task that was very tedious that few in the offices wanted to deal with. The net savings in man hours was about 16 to 20 hours per week or the equivalent of part time employee's salary.
Net savings in a professional office was significant enough to justify project.
Payroll Savings: $15,000
Project Cost: $4,000
Subscribe to:
Comments (Atom)
