Here's part of our SF structure:

Parent Campaign A ( 0 members )

Campaign A.A ( 10 members )

Campaign A.B ( 50 members )

...

Campaign A.Z ( 700 members )

Parent Campaign B ( 0 members )

Campaign B.A ( 532 members )

Campaign B.B ( 1,000 members )

...

Campaign B.Z ( 321 members )

... So on and so forth.

Now our organization wants to know how many unique members are in each parent campaign.  If a contact belongs to Campaign B.A and Campaign B.B, then that contact will show up twice for counting all members who is in a campaign belongs to Parent Campaign B.

The CampaignMembers object has over 300,000 records. I thought about pulling the contactID and the ParentID out using joins, but I'll only pull 2,000 records at a time with the current limitations.

Any ideas how to get the number of unique members from each parent campaign?

I'm trying to create a report that will give me every contact whose Mailing Address is different from their Account's Shipping Address.

Any ideas how to do this through Salesforce's Report tool?

Our organization would like to convert all Person Accounts to Contacts. We would like the converted contact to be connect to an account named, "Generic Contact."  I looked into this a little and this is what I found out. 

Option 1:

Each Person Account has a record in both the Account table and Contact table.  The Contact table holds all the Person Acount information.  The Contact table has a field called IsPersonAccount which is marked true. I would like to change the IsPersonAccount to false, change the AccountId to that of the "Generic Contact" account and Delete the Account with the old AccountId.

Whenever I try to change the IsPersonAccount to false, I get an error "INVALID_FIELD_FOR_INSERT_UPDATE".

Option 2:

Now I can export the contacts to a csv file and  filter out all contacts with business accounts leaving the Person Accounts.  Then I can delete all Person Accounts and import the people in my csv file as contacts.  Finally, reconnect all compaigns using the PHP API.  

I would much rather change the AccountId and IsPersonAccount fields  (much less work).  Is there anyway to do option 1 or is there a better way of converting PersonAccounts to Contacts?

I'm working on a visualforce email template.  I'm having a problem pulling the account name.  Here's what I tried:

<messaging:emailTemplate subject="Send Catalog" recipientType="User" relatedToType="Contact"> <messaging:plainTextEmailBody >

...

Name: {!relatedTo.Name} Email: {!relatedTo.Email} Title: {!relatedTo.Title} School: {!relatedTo.Account__r.Name} Street: {!relatedTo.MailingStreet} City/State/Zip: {!relatedTo.MailingCity}, {!relatedTo.MailingState} {!relatedTo.MailingPostalCode}

...

</messaging:plainTextEmailBody> </messaging:emailTemplate>

 I'm having problems here:

School: {!relatedTo.Account__r.Name}

Our organization would like to convert all Person Accounts to Contacts. We would like the converted contact to be connect to an account named, "Generic Contact."  I looked into this a little and this is what I found out. 

Option 1:

Each Person Account has a record in both the Account table and Contact table.  The Contact table holds all the Person Acount information.  The Contact table has a field called IsPersonAccount which is marked true. I would like to change the IsPersonAccount to false, change the AccountId to that of the "Generic Contact" account and Delete the Account with the old AccountId.

Whenever I try to change the IsPersonAccount to false, I get an error "INVALID_FIELD_FOR_INSERT_UPDATE".

Option 2:

Now I can export the contacts to a csv file and  filter out all contacts with business accounts leaving the Person Accounts.  Then I can delete all Person Accounts and import the people in my csv file as contacts.  Finally, reconnect all compaigns using the PHP API.  

I would much rather change the AccountId and IsPersonAccount fields  (much less work).  Is there anyway to do option 1 or is there a better way of converting PersonAccounts to Contacts?

I'm working on a visualforce email template.  I'm having a problem pulling the account name.  Here's what I tried:

<messaging:emailTemplate subject="Send Catalog" recipientType="User" relatedToType="Contact"> <messaging:plainTextEmailBody >

...

Name: {!relatedTo.Name} Email: {!relatedTo.Email} Title: {!relatedTo.Title} School: {!relatedTo.Account__r.Name} Street: {!relatedTo.MailingStreet} City/State/Zip: {!relatedTo.MailingCity}, {!relatedTo.MailingState} {!relatedTo.MailingPostalCode}

...

</messaging:plainTextEmailBody> </messaging:emailTemplate>

 I'm having problems here:

School: {!relatedTo.Account__r.Name}