Search:

Type: Posts; User: mrabrams; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    7
    Views
    4,673

    Just my 2 cents: Every once in awhile, this...

    Just my 2 cents:

    Every once in awhile, this happens to me. No rhyme, no reason.

    When it happens, I go to:
    Tools/Options/Calculation tab.

    Somehow, the "Manual" radio button is checked.
    ...
  2. Thank you so much Deborah - it works perfectly...

    Thank you so much Deborah - it works perfectly now !! Much appreciated.

    Michael
  3. Using Windows XP/Excel 2003. I have attached...

    Using Windows XP/Excel 2003.

    I have attached the spreadsheet in question (which will actually have ten tabs similer to these)..
    What I want to do, is be able to type in the Date (manually) for...
  4. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    Oops, I'm sorry, I should have seen that. Since...

    Oops, I'm sorry, I should have seen that. Since you separate the names with semi-colons, you should change the line

    ARR = Split(Recip, ",")

    to

    ARR = Split(Recip, ";")


    That did it !! ...
  5. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    I am so sorry for being a PITA, but using the...

    I am so sorry for being a PITA, but using the below code does put both names into the TO line of the email but when Outlook opens and I click send, the same message appears:
    Microsoft Office Outlook...
  6. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    You should obviously remove the line ...

    You should obviously remove the line

    EmailSend.Recipients.Add (mYRecipient) 'first add the email or user as a recipient


    Obviously !! ...
  7. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    OK I am getting closer. I moved the code: ...

    OK I am getting closer.

    I moved the code:

    Now when the email pops up, it has both names TWICE.



    Private Sub SendMessage(Recip As String)
  8. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    There's some confusion here because you and I use...

    There's some confusion here because you and I use the variable Recip for different purposes. Change the line

    Set Recip= EmailSend.mYRecipient.Add(arr(Counter))

    to

    Set objRecip=...
  9. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    You'll have to modify it to fit in with the your...

    You'll have to modify it to fit in with the your own code, of course.
    Of course http://windowssecrets.com/forums/images/smilies/smile.gif

    It is getting stuck asking for "Object required" on...
  10. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    You have to use the Split function to create an...

    You have to use the Split function to create an array of recipient names, and add them one by one. The code of the SendMail function shows how to do that:


    Function SendMail( _
    Recipient As...
  11. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    The SendMail function in the attachment to Post...

    The SendMail function in the attachment to Post 728849 shows how to handle multiple recipients in a string, separated by semi-colons.

    Using the example:
    SendMail "john@this.com;mary@that.org"
    ...
  12. Thread: SENDMESSAGE

    by mrabrams
    Replies
    15
    Views
    794

    I am using the following code successfully behind...

    I am using the following code successfully behind a command button:

    Private Sub cmdSend_Click()
    On Error GoTo Err_cmdSend_Click

    SendMessage ("FranklJ@sutterhealth.org")

    Exit_cmdSend_Click:...
  13. Replies
    12
    Views
    811

    First of all, I would like to thank Hans for your...

    First of all, I would like to thank Hans for your patience and pieterse for the tutorial.

    You guys are awesome and I really appreciate the time you take to share your knowledge (and patience)
    ...
  14. Replies
    12
    Views
    811

    If a toolbar is docked at the top of the Excel...

    If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn't displayed, only the buttons. When you undock it (use the...
  15. Replies
    12
    Views
    811

    Make sure that you drop the macro squarely on the...

    Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)
    This is so...
  16. Replies
    12
    Views
    811

    I created the custom toolbar (Reports) When I...

    I created the custom toolbar (Reports)

    When I drag a custom button from Commands/Macros to the new toolbar, the title Reports goes away, and the macro IS the toolbar. There is no 'dropdown'. I...
  17. Replies
    12
    Views
    811

    You could try opening the .xlb file and see if...

    You could try opening the .xlb file and see if that works. If not, you'll probably have to reassign the macros to the toolbar buttons one by one.

    Looks like it's going to be 1 by 1. So...
  18. Replies
    12
    Views
    811

    I borrowed a coworker's Personal.xls &...

    I borrowed a coworker's Personal.xls & Excel11.xlb files. ( I created them for her and now my computer crashed)

    The personal.xls works fine. All of the macros are there and function OK.

    I...
  19. Thank you Hans - EXACTLY what I was looking for....

    Thank you Hans - EXACTLY what I was looking for.

    Michael
  20. I hope I am describing this accurately: Column...

    I hope I am describing this accurately:

    Column M (April 2009)
    Column N (May 2009)
    Column O (formula) =SUM(N6-M6)

    For June, I copy Column N and insert it to the right of Column N (becoming...
  21. Replies
    4
    Views
    943

    Perfect. Thank you Hans. Michael

    Perfect. Thank you Hans.

    Michael
  22. Replies
    4
    Views
    943

    Thank you Hans, The worksheets are not...

    Thank you Hans,

    The worksheets are not password protected.

    Where can I put the messagebox code?

    Thank you,
    Michael
  23. Replies
    4
    Views
    943

    I would like to delete all data on a spreadsheet...

    I would like to delete all data on a spreadsheet after a certain date.

    Pseudo code (On Workbook Open):

    If date > (hard coded date) then delete all data on worksheet
    And message box (OK only)...
  24. Replies
    7
    Views
    693

    Hi Steve - That one is pretty cool too. I'll...

    Hi Steve - That one is pretty cool too. I'll give it a shot.

    Thank you very much !!

    Michael
  25. Replies
    7
    Views
    693

    I couldn't get the right syntax but what you...

    I couldn't get the right syntax but what you offered worked fine !
    =OR(B2="Choice1",B2="Choice2",B2="Choice3")

    Thank you Hans !

    Michael
Results 1 to 25 of 491
Page 1 of 20 1 2 3 4