Export Excel Contact info to simple XML schema

I want to regularly export Outlook contact info into a simple XML format for import into the Address Book on Cisco 7921G phone handsets. I'll export from Outlook into Excel, where a simple one-row-per-record layout results.

I then want you to write a macro/VB script within Excel that will do the following:

1. Prompt for a folder to put the output.

2. Create a single file with a filename of "YYMMDD HHMM Contact export for Cisco phones.xml" The Y, M, D, H and M characters should represent the date and time that the file was created.

3. Write each contact into the file in the following format:



<N Family="lastname"



<ORG Orgname="company"/>

<TEL type="work" spddial=x PREF=1>0123567546</TEL>

<TEL type="home" spddial=x>0123435463456</TEL>

<TEL type="cell" spddial=x>04123345656</TEL>

<TEL type="other" spddial=x>0412343546546</TEL>

<ADR type="home" Street="street number and name"


Pcode="pc" Region="state"


<EMAIL type="internet">email</EMAIL>




4. Note that blank fields should not be included in the output file.

5. The speedial (spddial=x) value x should be incremented from 2 to 99.

6. An error should be generated if there are more than 98 separate contacts in the output.

7. Once the speeddial number "99" is allocated to a phone number, additional phone numbers should not have the text "spddial=x" in the TEL line. They won't have a speeddial, but will still be there.

8. The macro should work with Outlook 2007, Excel 2007 and Vista.

9. You have to provide the source as well, which will become my property.

A clarification - I'm expecting an Excel macro only. I mention Outlook 2007 only to allow bidders to see what the output to Excel looks like by doing their own export.

Kemahiran: Excel, Visual Basic, Destop Windows, XML

Lihat lagi: export outlook contacts xml, export excel 2007 xml, excel 2007 export xml, speelschema excel, xml schema excel 2007, excel 2007 schema, excel xml export quot, contact outlook 2007 import export xml vbnet, export data xml excel 2007 xsd, excel 2007 export xml schema, schema excel budgettering, excel 2007 xml export xsd, save excel xml schema, format output simplexml, excel budget scheme, vba export xml format, xml schema outlook contacts, outlook contacts export xml, export contacts xml, outlook contacts xml export, excel xml export, excel macro export xml, work from home phones, work from home org, value city

Tentang Majikan:
( 5 ulasan ) Wahroonga NSW, Australia

ID Projek: #262738

Dianugerahkan kepada:


Please see the PMB for a 'excel contacts to xml' demo.

$30 USD dalam 0 hari
(1 Ulasan)

13 pekerja bebas membida secara purata $102 untuk pekerjaan ini


VBA developer since 1997. I hope I get it right - it is about Excel macro only, not both Outlook and Excel, isn't it? Anyway, my bid is for the Excel macro as decribed above. Excel 2007 available. Can do. Regards, Svet Lagi

$150 USD dalam 3 hari
(78 Ulasan)

plz view pm i have short cut for you...

$250 USD dalam 3 hari
(35 Ulasan)

I will be pleased to apply my 12+ year experience with VB/VBA/VBS (programming for Excel inclusive) to completing your project. Please see more details in PM

$120 USD dalam 2 hari
(10 Ulasan)

Hi. I've recently done the similar project. I can do it for you. Thanks.

$60 USD dalam 3 hari
(20 Ulasan)

Thank You for consideration!

$50 USD dalam 5 hari
(1 Ulasan)

We can do you project. Please check your PM. Thanks!

$250 USD dalam 12 hari
(0 Ulasan)

Hiii, I can easily do that. The cost is minimum.

$30 USD dalam sehari
(0 Ulasan)


$150 USD dalam 3 hari
(0 Ulasan)

can do in short order...If you pay over $40, you've paid too much for this type of project.

$40 USD dalam 2 hari
(0 Ulasan)

I got a vast experience in this kind of project and I can able to finish within the specified period with great accuracy.

$70 USD dalam sehari
(0 Ulasan)

can be well done!

$30 USD dalam 3 hari
(0 Ulasan)

Hi, I think I was the man you are looking for, I have good experiences on Visual basic macro developing, I have finished several projects on this field, such as Excel Dialer. I can get it done with rapidly response an Lagi

$90 USD dalam 3 hari
(0 Ulasan)