Yes it has to do with how the date is displayed. Here is what I have so far
and below that is a sample of what is being returned. There will always be
a start and end date, but the number of members is not always consistant and
the data for each person is very inconsistant. So the mail merge has more
blank listings then current members so if any members get added they will
automatically be included when I mail merge and all of the headings and
spaces are part of the merge fields (MERGEFIELD WORK_FAX \b "Bus. fax: " )
so if someone doesn't have a Bus. fax then it won't say Bus. fax with a blank
after it.
«TITLE» «FIRST_NAME» «MI» «LAST_NAME» «START_DATE»«Space»«END_DATE»
«POSITION», «COMPANYUNIVERSITY»
«WORK_ADDRESS»
«WORK_ADDRESS_2»
«WORK_CITY», «WORK_STATE» «WORK_ZIP»
Bus. phone: «WORK_PHONE»
Bus. fax: «WORK_FAX»
«WORK_EMAIL»
Assistant: «ASSISTANT_NAME» ~ «ASSISTANT_PHONE» ~ «ASSISTANT_EMAIL»
«HOME_ADDRESS»
«HOME_ADDRESS_2»
«HOME_CITY», «HOME_STATE» «HOME_ZIP»
Home phone: «HOME_PHONE_»
Home fax: «HOME_FAX»
«HOME_EMAIL»
Cell Phone: «CELL_PHONE»
Dr. Sam T. Brown 01/01-05/08
General Partner, Small business
The ABC Company
PO Box 1111
Boise, ID 11111-0000
Bus. phone: 208-111-1111
brown@smallbusiness
Assistant: Jean ~ 208-111-1111
111 2nd st.
Moscow, ID 11111
Home phone: 208-311-1111
[email protected]
Cell Phone: 208-111-1111
