Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-07-2011, 06:34 AM
macropod's Avatar
macropod macropod is offline Mail with macro Excel 2010 Windows 7 64bit Mail with macro Excel 2010 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Santors,

Regarding the date, what is the error message? Also, you could simplify that line with:
strDate = Format(Now, "DD-MM-YY h-mm-ss")

As for the Save As, what is the error message? Have you tried specifying the fileformat (it's one of the Save As parameters)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for sending mail and opening the sent mail afterwards Rumlegok Outlook 0 09-20-2011 07:27 AM
Mail with macro Excel 2010 Word Doc Macro (mail Merge) ajolson1964 Word VBA 1 05-10-2011 10:15 PM
Mail with macro Excel 2010 Run a Macro in Word 2010 Joyce301 Word VBA 3 04-29-2011 03:27 PM
utlook 2010 is not receiving G-mail (IMAP) E-mail CGChicago Outlook 0 12-28-2010 03:49 PM
Error: general mail failure. Quit excel restart mail system MitchellDM Outlook 1 12-19-2008 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 PM.


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