Search results

  1. M

    Extracting cell data from table

    After the row with "full-name" is found, again use Instr in that row to find the next <td> and </td>. The text between both is the value you're looking for.
  2. M

    Adding a contact to Outlook with a custom form using Access VBA

    You need to set the MessageClass property of the contact to the name of your custom form.
  3. M

    Macro to send email after changing from address and adding signature

    See the SendUsingAccount property for setting the account, or see SentOnBehalfOfName for setting an address (this works only with an Exchange account). Good luck for the signature, since OL 2013 there's no easy way. Best approach could be to save a template for each account/signature, and send...
  4. M

    Extracting only one recipient from Msgitem.To

    Even if there's only one recipient, Split returns an array with one item, so you can always use arr(0) and don't need the If-Else thing. Even if there's only one recipient, Split returns an array with one item, so you can always use arr(0) and don't need the If-Else thing.
  5. M

    Calling one module from another

    The fist step is ok, move the part you want to move to the new module. Then feed the new function with all the values it needs, for instance strMsgSubject. As strMsgSubject is filled in the old function, it is unkown or empty in the new one. So, to pass that one value the function declaration...
  6. M

    Extracting only one recipient from Msgitem.To

    I'd use the Split function, and split the To property by the semicolon. It returns an array, it's first item is what you're looking for.
  7. M

    Relocating archive.pst file

    It only needs to be accessible when the archiving procedure is is running.
  8. M

    Printing tasks with multiple categories

    Wouldn't it print each item just once, if you don't group by categories?
  9. M

    Integrating Outlook and Projectwise

    I'd contact the vendor of ProjectWise. If they offer that API, they'll know how to use it.
  10. M

    Office 2016, 32 vs 64 bit

    The only benefit of 64bit is large files, which most people don't need.
  11. M

    Autoforward emails to different contacts based on certain criteria using only one rule

    All a rule could do here would be to trigger a script for only those emails you want to forward. For all of the rest you need to write that script. Here's a sample that's not triggered by a rule, but as soon as an item is added to your inbox. It searches a contact by the sender address of the...
  12. M

    Forward message to address from subject

    Try to add this: dim fw as mailitem set fw=item.forward fw.t0=item.subject fw.subject=... fw.send
  13. M

    Save message from outlook to desktop in 2013 outlook

    There's nothing wrong with the code except this line: oMail = objItem should read set oMail = objItem
  14. M

    Automatically file email messages

    If you manually run the rules, you can apply them to any folder.
  15. M

    Where are Outlook categories save for IMAP?

    The DASL name for that property is "urn:schemas:mailheader:keywords". The ID is "Keywords", the GUID "{00020329-0000-0000-C000-000000000046}"
  16. M

    How to make a copy of a task

    Another drawback of copy&paste is that it also copies the search_key property of the original item. The one or other sync tool could have its problems with that.
  17. M

    How to make a copy of a task

    This macro creates a copy of the selected task item: Create a New Journal Item Based on an Existing One - VBOffice
  18. M

    newb outlook macro help

    This should get you started: Send an Email Template - VBOffice
  19. M

    copy data in Custom Field to other folder

    See the BeforeItemPaste event of the Explorer object. You can get a ref on the dragged item via the ClipboardContent variable, which is a Selection object in this case. Here read the user props of the dragged items. The next event that should trigger is the NewInspector event, which gives you a...
  20. M

    Export Outlook custom forms fields to excel

    You can access user props this way:... = Folder.Items.Item(iRow).UserProperties("name").Value
Back
Top