Office Pro Plus 2007 Integrating Access Contacts w - Free Advertising Forums | Free Advertising Board | Post Free Ads Forum | Free Advertising Forums Directory | Best Free Advertising Methods

05-12-2011, 04:38 PM

There was a query on our publish about finding Entry to realize tables as exact WSS table templates around what else you ought to do to acquire the new Add From Outlook characteristic to labor on a customized contacts table. This aspect uses the same mechanism to determine that a table is a contact table,Office Pro Plus, but more than that it needs to know how to map fields in your table to those in the Outlook contact store. There are a bunch of fields, so easier than building this out yourself, here's a quick snippet of VBA that will take any table, and make it into a contacts table. Just plop this into your solution, then update the table name and field names to reflect the fields in your customized contacts implementation, and run it. -----------------------------------------------
' READ THIS
' Make edits to the string values in the
' MakeContacts Sub below to match up
' with your table and field names.
'
' You shouldn't have to change the rest of
' this code.
' -----------------------------------------------
' CI is for ContactInfo
Enum CI
First
Last
Email
Company
JobTitle
WorkPhone
HomePhone
CellPhone
WorkFax
WorkAddress
WorkCity
WorkState
WorkZip
WorkCountry
WebPage
Comments
End Enum
' Each field map item maps between a field
' name in the Entry table and a property
' name Access maps to Outlook and SharePoint
' contact field info.
Type FieldMap
prop As String
Field As String
End Type
' This Varible lists all the proeprties that
' can be mapped to Contact info. You fill
' it with the corresponding field names from
' your table.
Dim Map(CI.Comments) As FieldMap
Public Sub MakeContacts()
Dim strTable As String
Dim fm As FieldMap
Dim td As TableDef
Dim db As Database
' -----------------------------------------------
' UPDATE THESE STRINGS
' to match the table and field names in
' your app. It is okay not to set some if you
' don't have an equivalent.
' Set this to your table name
strTable = "Table1"
' Set these to your field names
Map(CI.First).Field = "First"
Map(CI.Last).Field = "Last"
Map(CI.Email).Field = "Email"
Map(CI.Company).Field = "Org"
Map(CI.JobTitle).Field = "Job"
Map(CI.WorkPhone).Field = "Work"
Map(CI.HomePhone).Field = "Home"
Map(CI.CellPhone).Field = "Cell"
Map(CI.WorkFax).Field = "Fax"
Map(CI.WorkAddress).Field = "Addr"
Map(CI.WorkCity).Field = "City"
Map(CI.WorkState).Field = "State"
Map(CI.WorkZip).Field = "Zip"
Map(CI.WorkCountry).Field = "Country"
Map(CI.WebPage).Field = "WWW"
Map(CI.Comments).Field = "Notes"
' END OF STRINGS TO UPDATE
' -----------------------------------------------
' This the code to mark fields in
' your local table with the correct
' Outlook and SharePoint field names.
'
' You shouldn't have to change this.
SetupContactProps
Set db = CurrentDb
Set td = db.TableDefs(strTable)
' Set the table level property that tells Access
' this is a Contact table.
SetProp td, "WSSTemplateID", dbInteger, 105
' For each mapped field, set the correct
' contacts property.
For i = 0 To CI.Comments
fm = Map(i)
If Len(fm.Field) > 0 Then
SetProp td.Fields(fm.Field), "WSSFieldID", dbText, fm.prop
End If
Next
End Sub
' This code initializes the contact property
' names that Access uses to map contact info
' to SharePoint or Outlook.
'
' You shouldn't have to change this.
Sub SetupContactProps()
Map(CI.First).prop = "FirstName"
Map(CI.Last).prop = "Title"
Map(CI.Email).prop = "Email"
Map(CI.Company).prop = "Company"
Map(CI.JobTitle).prop = "JobTitle"
Map(CI.WorkPhone).prop = "WorkPhone"
Map(CI.HomePhone).prop = "HomePhone"
Map(CI.CellPhone).prop = "CellPhone"
Map(CI.WorkFax).prop = "WorkFax"
Map(CI.WorkAddress).prop = "WorkAddress"
Map(CI.WorkCity).prop = "WorkCity"
Map(CI.WorkState).prop = "WorkState"
Map(CI.WorkZip).prop = "WorkZip"
Map(CI.WorkCountry).prop = "WorkCountry"
Map(CI.WebPage).prop = "WebPage"
Map(CI.Comments).prop = "Comments"
End Sub
' This is a helper routine which sets a property
' value first checking to see whether one already
' exists.
Sub SetProp(o As Object,Office Pro Plus, strProp As String,Office 2010 Download, dbType As DataTypeEnum, oValue As Variant)
Dim p As Property
On Error GoTo NotFound
Set p = o.Properties(strProp)
GoTo Found
NotFound:
Set p = CurrentDb.CreateProperty(strProp, dbType,Office Pro Plus 2007, oValue)
o.Properties.Append p
Found:
If p.Type = dbType Then
p.value = oValue
Else
o.Properties.Delete (strProp)
Set p = CurrentDb.CreateProperty(strProp, dbType,Office Pro 2010, oValue)
End If
End Sub

05-12-2011, 04:39 PM

Reflections of a Royal Bridesmaid
Published On:Wednesday, April 27, 2011
By MEGAN REYNOLDS
Tribune Staff Reporter
mreynolds@tribunemedia.net
AS the Bahamas' own inhabitant constituent of the British regal family India Hicks organises for the regal marriage of Prince William and Kate Middleton on Friday, she recognises fond recollections of her own participation in Prince Charles and the late Lady Diana Spencer's marriage when she was just 13.
On July 28 1981, the progeny of Lord Louis Mountbatten, the last Viceroy of India Purple Bridesmaid Dresses, and goddaughter of His Royal Highness Prince Charles the Prince of Wales, was ascribed with the monumental blame of devising his bride, Lady Diana's 25ft dress train.
The task was as intimidating as the record-breaking extent of the train itself for the tomboyish teenager who favoured jodphurs to frills and finery.
She had slash off her long hair and was on vacation with her family at their dwelling in Windemere Island, in Eleuthera, when she obtained the swamping request from her beloved Godfather.
Although shocked by the outlook of wearing not only wearing a dress, but wearing it in front of an assembly of 750 million, Ms Hicks said she was pleased to have been inquired by the "caring, considerate and involved" godfather who she adored as much then as she does today.
Ms Hicks, who has dwelled in Harbour Island for 16 years and increased her young children in the community, said she had expended time on vacation with Prince Charles at the family dwelling in Eleuthera as a child.
Her function as bridesmaid permitted her to spend value time with his new bride in the weeks before the marriage bridesmaid dresses, in the intimate setting of dress designer's David and Elizabeth Emmanuel's studio, where the bridesmaids patiently remained hour after hour as the dress's every line and bend was perfected.
Young India was whisked away from her British boarding school and up to London under a shroud of secrecy to bypass the famished press photographers.
There Ms Hicks and the Queen's niece Sarah Armstrong Jones performed bending and developing a 25ft dustcloth joined to Diana's waist with fastidious precision, only to be swamped on the day.
"Manipulating that much ivory taffeta and antique lace in and out of little state carriages impersonated substantial complications," she said.
"Needless to state on the day itself, with close to a billion persons observing, fright took over, and we resorted to rather many of impelling and shoving and creasing."
As with the marriage of Prince William and Kate Middleton, Prince Charles and Lady Diana's marriage was announced a nationwide holiday
"Royal marriage rush grew Sheath Bridesmaid Dresses," Ms Hicks said.
"People arranged to commemorate with road parities. Bonfires were constructed, so they could flare up over the homeland, in commemoration on the day itself."
On the eve of the marriage, July 28, half a million persons accumulated in London's Hyde Park to glimpse the cannons of the King's troop, the Royal Horse Artillery blaze a salute to assess the first wedding ceremony of a Prince of Wales for 118 years, and the unprecedented firework brandish that followed.
Ms Hicks and Sarah Armstrong Jones observed the brandish with remainder of the Royal family Gold Bridesmaid Dresses, and as the rushing gatherings dispersed bridal dresses, and traffic stood at a standstill, it became clear-cut she was attached with them for the night.
Princess Margaret asked for India to stay at Kensington Palace, and even suggested her the use of her toothbrush, departing a lasting effect on India.
Early the next forenoon she was taken to Clarence House, the Queen Mother's house, where she contacted a fresh-faced Diana, clothed in vintage casual trousers and precious gem tiara, observing herself on a minute TV computer display in the nursery, in a playful mood.
"She would flick any individual who got in the way," India said.
"During one financial shatter the advert for Cornetto ice elite came on and she begun vocalising, shortly we all connected in."
The bridesmaids were escorted below as Diana was clothed, and India said she apparently recalls the instant the Princess-to-be emerged at the peak of the staircase and every individual dropped silent.
Crowds topped up the roads of London for glimpse of Lady Diana and her dress cheap bridesmaid dresses, as she was propelled to St Paul's Cathedral in the glass carriage.
India and Sarah contacted her at the Cathedral to assist her out of the carriage and organise her train and veil.
"State trumpeters rang out fanfare. A hushed quiet pursued before the marriage stride began. It took Diana V-neck Bridesmaid Dresses, on the shaky arm of her dad Earl Spencer, with her five bridesmaids and two sheets in attendance Empire Bridesmaid Dresses, three-and-a-half minutes to stroll up the red-carpeted aisle, before the large-scale accumulating of European crested heads and foreign royals, an asked for congregation of 3,500 and a international assembly of 750 million."
As the world's most-watched marriage observance drew to a close Chiffon Bridesmaid Dresses, India and the bridesmaids were conveyed to Buckingham Palace in the glass carriage Diana had reached in.
"Of course at the time it appeared a flawlessly usual mode of transport, trotting down the shopping centre in a equine drawn adviser, only somewhat wrecked by the tears of six year vintage Catherine Hambro, who turned out to be highly allergic to horses. However looking back that should have been my fairytale moment.
" The newlyweds took the open-topped state landau to Buckingham Palace, where they appeared on the balcony to give the gatherings the kiss they had been yearning to see."
"Nothing could have arranged me for the view of the gatherings that day.
"We observed in awe as the micro dimensions, navy azure line of climbed on policeman were compelled to brake grade as the swarming masses inundated through from the shopping centre to the barriers of the castle, shouting happily for Charles and Diana."
The marriage morning serving of food was joyful, talks by Prince Andrew and Prince Edward, light-hearted and funny, and when the baked cake had been slash, Diana went to change into her going-away outfit with aid from her sisters and her bridesmaids.
" The feeling was girly and giggly and Diana provided us each a present, and a kiss, thanking us for being there," India said.
"And then she was gone. Whisked away over the Buckingham Palace enclosed backyard, with a 'just married' signal and vintage containers adhered to the landau by Andrew and Edward, lifting grins from The Queen, The Queen Mother and Princess Margaret, who hotfooted after it, joking and waving. An odd view indeed.
The wed twosome was propelled over Westminster Bridge to get the train to Hampshire, to start their honeymoon, in my grandfather's dwelling, Broadlands. "
India Hicks will be supplying reside treatment of the Royal Wedding on Friday.Topics related articles:

http://holiday.h-club.ru/forum/showthread.php?t=122589

http://shshbj.com/viewthread.php?tid=218740&pid=420469&page=1&extra= page%3D1#pid420469

http://www.h-desk.com/viewtopic.php?hpr=What_is_the_way_to_Starting_XP_f rom_DOS_prompt_&p=57136#57136

http://forum.warmachine.raven-distri...=199419#199419

http://www.vgchat.com/happy-april-t40617.html

05-12-2011, 04:43 PM