Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2004

Tip: Looking for answers? Try searching our database.

Merge to Fax Macro by Peter Jamieson

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
IronJackKidd - 13 Jan 2004 21:01 GMT
Hi There
I've used the Merge to fax macro previously posted in this group to accomplish the fax merge I was working on, and many thanks to you Mr Jamieson for that. What I'm wondering at the moment is how to get the fax console to use a dialing rule I've set up. Is it possible to set this option on the send line of this macro
Thanks
Peter Jamieson - 14 Jan 2004 10:25 GMT
What kind of dialling rule are you talking about. and where exactly are you
setting it up? Is this on Windows XP?

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi There,
> I've used the Merge to fax macro previously posted in this group to accomplish the fax merge I was working on, and many thanks to you Mr
Jamieson for that. What I'm wondering at the moment is how to get the fax
console to use a dialing rule I've set up. Is it possible to set this option
on the send line of this macro?
> Thanks
IronJackKidd - 14 Jan 2004 19:16 GMT
Hi Peter
Yes this is windows XP, the dialing rules are configured in the phone and modem options in the control panel allowing the appropriate long distance code to be prefixed to the phone number. The fax console allows an option to use these rules when sending a single fax, so I was wondering if this option could be specified at the moment of the fax send in the macro. Hope this is clearer
Peter Jamieson - 15 Jan 2004 10:48 GMT
OK, I suspected that was what you meant but wondered if I'd missed an option
somewhere.

As far as I can see (and in fact this is still unfamiliar territory for me)
a. the options you get when you use e.g. File|"Send a fax" in Fax console
to send a single fax are /probably/ just applied to that single fax. That
option simply seems to build a complete dialling string - in my case, e.g.
+44 (0161) xxx xxxx.
b. I couldn't find any option that allows you to apply the dialling rules
to all faxes sent via the fax service.
c. the fax service documentation suggests that if the faxnumber you provide
to the macro contains a canonical fax number, then any outbound /routing/
rules will be applied. However, my understanding is that those rules are
really about selecting which device to use, rather than about how to
construct a diallable phone number with, e.g. long distance prefix where
necessary.

So the only thing I can suggest is that if you are not starting with numbers
in canonical format, you try that to see if it makes any difference (FWIW
whenever I try to create rules here, the MS software appears to construct a
number that does not actually conform to UK dialling conventions, which
suggests that either I am doing something wrong or that the software is. But
it certainly makes it impossible to test anything in this area).

e.g. if the number is in the US, try using

+1 (aaa) 555-1234

where aaa is the area code, rather than just e.g. aaa5551234 or whatever you
actually have at the moment.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi Peter,
> Yes this is windows XP, the dialing rules are configured in the phone and modem options in the control panel allowing the appropriate long distance
code to be prefixed to the phone number. The fax console allows an option to
use these rules when sending a single fax, so I was wondering if this option
could be specified at the moment of the fax send in the macro. Hope this is
clearer.
IronJackKidd - 16 Jan 2004 05:06 GMT
Hi Peter,
Thanks for that, I'll give the canonical number format a whirl and post the results.
Cheers
IronJackKidd - 01 Feb 2004 23:51 GMT
Apologies for the delay in posting, the phone number merge data I'm using is in an Excel spreadsheet in a field which wouldnt allow use of the + character so I still don't know if use of the canonical format solves the problem. I had the person using the merge change the numbers to include the necessary dial codes. It's a pity that the use of dialing rules is not specifiable in VBA it would be a useful addition
Peter Jamieson - 02 Feb 2004 10:57 GMT
I think you could probably build a canonical format number with some
additional VBA in the macro I posted but
a. you would obviously have to know the rules applicable to the phone
numbers you have (maybe they are quite simple, but I am not the person to
ask!)
b. it sin't something I was planning on doing.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Apologies for the delay in posting, the phone number merge data I'm using is in an Excel spreadsheet in a field which wouldnt allow use of the +
character so I still don't know if use of the canonical format solves the
problem. I had the person using the merge change the numbers to include the
necessary dial codes. It's a pity that the use of dialing rules is not
specifiable in VBA it would be a useful addition.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.