Everything works except one thing. The time in Column C is being pasted into the email in decimal format. How can I alter this to keep the time format?
Please Login or Register to view this content.
Everything works except one thing. The time in Column C is being pasted into the email in decimal format. How can I alter this to keep the time format?
Please Login or Register to view this content.
Last edited by eriknokc; 05-19-2009 at 04:09 PM.
Hello ericnokc,
Use the cell Text property instead of the Value.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you so much for your help. I have done it before but it slipped my mind and I was completely baffled by it cause I knew it was easy. Again, I really appreciate it.
One last question on this particular macro. Is there a way to specify in this macro a specific account/email address that I would like the email to send from?
One last question on this particular macro. Is there a way to specify in this macro a specific account/email address that I would like the email to send from?
Hello eriknokc,
You can only send from your own account, to other peoples accounts. You can't send mail for them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks