[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Fax Cover Sheet Macro - Date Field does not pick up system time

Posted on 2006-04-28
Medium Priority
Last Modified: 2010-04-08
BlueDevilFan answered my original question of "How to create a fax cover sheet in contacts by creating a macro"  This macro works great.  I have a problem with the date field it picks up 3/4/2006 every time instead of the current date.  I've looked through the faxcoversheet.txt document and I can't even find the line that refers to the field.  Please note my experience with macros is nil.  Any help would be appreciated.

Question by:averbeck
  • 3
  • 2
LVL 76

Expert Comment

by:David Lee
ID: 16564642
Greetings, averbeck.

Filling the date isn't handled by the macro.  It's litteral text typed into the page.  I can adjust that if you want so that the macro does handle it.  

As a side note, you should close the original question.  It's still open.


Author Comment

ID: 16564798
I would appreciate the adjustment

LVL 76

Accepted Solution

David Lee earned 1000 total points
ID: 16564916
No problem.  This should do it.

1.  Open the fax cover sheet HTML file, do a search on 3/4/2006 and replace it with *TODAYS_DATE*
2.  Add the following code to the macro.  Insert it immediately before the line containing "objMyFaxCover.WriteLine strBuffer".

        If InStr(1, strBuffer, "*TODAYS_DATE*") Then
            strBuffer = Replace(strBuffer, "*TODAYS_DATE*", Date)
        End If


Author Comment

ID: 16565210
This did it.  Do you have any recommendations on a book I could pick up that would walk me through creating macros?  Thanks for all your help.

LVL 76

Expert Comment

by:David Lee
ID: 16565370
You're welcome.  I've three books I depend on for the specifics of writing macros for Outlook/Exchange.

1.  Microsoft Outlook Programming, Sue Mosher, Digital Press, ISBN: 1-55558-286-9
2.  Programming Microsoft Outlook and Microsoft Exchange 2003, Thomas Rizzo, Microsoft Press, ISBN: 0-7356-1464-4
3.  Building Applications with Microsoft Outlook 2000 Technical Reference, Randy Byrne, Microsoft Press, ISBN: 0-7356-0581-5  (There's a newer version of this book for Outlook 2002.  Not sure about 2003.  I've not seen one, but I may simply have missed noticing it.)

Note that I said I use these references for the specifics of writing macros for Outlook.  They don't teach basic coding skills which is as important to the process as knowing what Outlook object does what, or what method to call to accomplish something.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
I came across an unsolved Outlook issue and here is my solution.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question