Search results for query: *

Hello. My 6 handsets all display the same time which is behind by 1 hour and 10 minutes. Nortel ICS/CallPilot configuration. I am not an expert, actually perhaps clueless. I am able to log into the CallPilot web interface and verify the Timezone on the System properties page. In fact, I have...

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...

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...

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...

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...

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...

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...

That did the trick. Thanks a bunch!

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...

yes, that is correct, thank you. Skip?

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...

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.

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...

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 ...

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...

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.

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...

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...

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...

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...