I gang

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:

<updateContact>

<vCard>

<N Family="lastname"

Given="firstname"/>

<NICKNAME>nickname</NICKNAME>

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

Locality="city"

Pcode="pc" Region="state"

Country="country"/>

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

<IMPP>im</IMPP>

</vCard>

</updateContact>

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.

Færdigheder: Excel, Visual Basic, Windows Skrivebord, XML

Se mere: 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

Om arbejdsgiveren:
( 5 bedømmelser ) Wahroonga NSW, Australia

Projekt-ID: #262738

Tildelt til:

cooldev

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

$30 USD in 0 dage
(1 bedømmelse)
1.2

13 freelancere byder i gennemsnit $102 for dette job

svet63

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 Mere

$150 USD in 3 dage
(78 bedømmelser)
6.7
azrajobs

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

$250 USD in 3 dage
(35 bedømmelser)
4.6
gvyshnya

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 in 2 dage
(10 bedømmelser)
4.2
vmalykh

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

$60 USD in 3 dage
(20 bedømmelser)
3.8
mdfiege

Thank You for consideration!

$50 USD in 5 dage
(1 bedømmelse)
3.6
daishushuu

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

$250 USD in 12 dage
(0 bedømmelser)
0.0
darknessends

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

$30 USD på 1 dag
(0 bedømmelser)
0.0
excelant

---------------------------------

$150 USD in 3 dage
(0 bedømmelser)
0.0
mattschuett

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

$40 USD in 2 dage
(0 bedømmelser)
0.0
sugapriyaGov

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 på 1 dag
(0 bedømmelser)
0.0
Sunnydang

can be well done!

$30 USD in 3 dage
(0 bedømmelser)
0.0
programmerofweb

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 Mere

$90 USD in 3 dage
(0 bedømmelser)
0.0