Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joemajestee

    Handset times behind 1:10

    ...on the System properties page. In fact, I have changed the timezone to see if it would affect the handset displays and it did not. I used the **TIME command on my handset to correct the time. The time stayed correct on all handsets for about 10 minutes then reverted. This started when I...
  2. joemajestee

    Switching one T7316 for another

    Hi all. I am not a phone person so I may not be asking the question correctly. Is there a way for me to take my working conference room phone that no one uses and switch it with another that works only not so well? Both phones are T7316 phones connected to a Nortel Compact PLUS ICS and...
  3. joemajestee

    Crystal error printing invoice batch

    I am not a MAS90 support person! but hope you guys can help. MAS 90, version 3.71, I think (went to Library Master, Utilities, Installed Apps) Windows XP. MAS 90 is installed on an old server (Win2K). Ran workstation setup on new XP system. When I go to print an invoice batch, after I hit...
  4. joemajestee

    use VBA to edit recipient list

    Hello all. I'm using word 2010 mail merge with an excel 2010 datasource. I would like to step through a set of values and filter the data, including only those records that contain value(x) in field(1) OR field(2) OR field(3). The values can be either hard coded or come from a different excel...
  5. joemajestee

    Set Outlook to offline mode via VBA code

    Figured it out. The following code in excel worked. Sub ToggleOutlookOffline() Dim OutApp As Object Set OutApp = CreateObject("Outlook.Application") MsgBox OutApp.session.offline OutApp.GetNamespace("MAPI").Folders.GetFirst.GetExplorer.CommandBars.FindControl(, 5613).Execute MsgBox...
  6. joemajestee

    Set Outlook to offline mode via VBA code

    There might be 100 emails to display. It's much easier and doesn't kill the computer memory if they just accumulate in the outbox. My normal process now is to go offline, run the macro, then look at a sample of the emails and go online. Invariably when I forgot to go offline first I find I've...
  7. joemajestee

    Set Outlook to offline mode via VBA code

    Hi there. Is there a way to make Outlook go into offline mode via VBA? Background: I'm sending stuff via Outlook from Excel using Dim OutApp As Object, OutMail As Object Set OutApp = CreateObject("Outlook.Application") ... I want to check if Outlook is online and set it to offline if online...
  8. joemajestee

    CCR - Delete a brand new menu from only tree

    That did the trick. Thanks a bunch!
  9. joemajestee

    CCR - Delete a brand new menu from only tree

    I'm totally new at this, sorry. I have a callpilot 100. Here's the bad thing I did: Logged into the web admin. Clicked on Custom Call Routing, saw trees 1 through 8, 2 and up are not defined. Clicked Change under tree 1 command. I don't know what possessed me, but I clicked Menu under Add: and...
  10. joemajestee

    Automatic correcting in Outlook

    yes, that is correct, thank you. Skip?
  11. joemajestee

    Automatic correcting in Outlook

    Because the only answer, if there is one, will be VBA. The emails are created using VBA and an existing outlook template. The template has placeholders for all of the possible data from each record. If the record doesn't require all of the placeholders, the placeholders remain in the template...
  12. joemajestee

    Automatic correcting in Outlook

    I'm not creating the html on the fly. All of the placeholders (headers) that might contain data are in the template. I can check for data, but I'd still have the problem of "headern" still being in the resulting email.
  13. joemajestee

    Automatic correcting in Outlook

    OK, thanks for the clarification. The excel spreadsheet has in row one what I'm gonna call headers. header1, header2, header2...header50 Each row has unique data record1, record2, etc. The outlook template file has text (formatted html) like this: Hello header1, Your entry number is header2...
  14. joemajestee

    Automatic correcting in Outlook

    Hi Skip. Sorry, juggling lots of things today. Not sure what you mean. But here's some of the excel code: Dim OutApp As Object, OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItemFromTemplate(strTemplate) strHTMLbody = OutMail.htmlbody ...
  15. joemajestee

    Automatic correcting in Outlook

    Hello, I have a macro in Excel 2003 that creates emails in Outlook 2003 using a .oft file. The emails end up with blank lines because not all of the records contain data for each line. Right now, the macro displays the emails so the user can delete all the blank lines before sending. I'm...
  16. joemajestee

    Word directory merge, page numbering problem

    Nevermind. Somehow word lost track of the fact that it was a directory. I stepped backward through the wizard and selected directory at the beginning, then went through to the end and all was as expected.
  17. joemajestee

    Word directory merge, page numbering problem

    Hi there, Word and Excel 2003 I did an 84 page directory merge from excel data. In the merge document I have a footer with the page number centered. After the merge, all of the pages are 1. After I complete the merge, I insert a table of contents at the beginning. The TOC labels every page...
  18. joemajestee

    Word mailmerge problem w/ excel database

    OK, this is now solved. I used Paul's solution. I shot myself in the foot by adding a second column to try to implement Skip's solution and named both columns the same, so my doc was grabbing the data from the inserted(test) column instead of the real column with the dummy record. I deleted...
  19. joemajestee

    folder redirection - outlook pst - offline not working

    I would not recommend using folder redirection for a notebook (portable) at all. Only use offline files. Folder redirection is designed for continuous network access so that all of a user's data is stored on the server for security, etc. I made the mistake of setting up users this way, too...
  20. joemajestee

    Word mailmerge problem w/ excel database

    Skip, you are absolutely right in that the data should be treated as text. I cannot think of a situation where I would wish to perform arithmetic on the data. Still, the users use numbers and then sort by those numbers and we are stuck using their data. Convert to text identifiers? Are you...

Part and Inventory Search

Back
Top