B
Boyd
I'm using a custom form (Outlook2003), published to the Organizational
Forms Library, for gathering budget data from users. Each user is
listed as a budget contact for records in my budget table
(Access2003).
My form currently contains 20 textboxes, which are populated using
Access VBA, looping thru all contacts in the table. The "To" field on
the form is populated with the current contact, and textboxes are
populated based on the # of budget records this contact person is
associated with in the table. For example, if John Doe is assigned to
10 budget records, the custom form will load data into the 1st 10
textboxes. However, if John Doe is assigned to 25 budgets, 2 outlook
forms will be populated (1 with 20 budgets and the 2nd with 5
budgets).
My problem comes into play when sending my custom form to contacts
with more than 20 budgets. When I attempt to do this, the 2nd form is
received by the contact person (only contains 5 budgets, as per the
example above), but the 1st form (holding 20 budgets) is never
received. Both forms are sitting in my 'Sent Items' folder, but the
person doesn't receive both forms.
I'm pulling my hair out trying to pinpoint the cause. Is the 2nd form
floating around in never-never land?
Any suggestions or work-arounds would be greatly appreciated.
Thanks,
Boyd
Forms Library, for gathering budget data from users. Each user is
listed as a budget contact for records in my budget table
(Access2003).
My form currently contains 20 textboxes, which are populated using
Access VBA, looping thru all contacts in the table. The "To" field on
the form is populated with the current contact, and textboxes are
populated based on the # of budget records this contact person is
associated with in the table. For example, if John Doe is assigned to
10 budget records, the custom form will load data into the 1st 10
textboxes. However, if John Doe is assigned to 25 budgets, 2 outlook
forms will be populated (1 with 20 budgets and the 2nd with 5
budgets).
My problem comes into play when sending my custom form to contacts
with more than 20 budgets. When I attempt to do this, the 2nd form is
received by the contact person (only contains 5 budgets, as per the
example above), but the 1st form (holding 20 budgets) is never
received. Both forms are sitting in my 'Sent Items' folder, but the
person doesn't receive both forms.
I'm pulling my hair out trying to pinpoint the cause. Is the 2nd form
floating around in never-never land?
Any suggestions or work-arounds would be greatly appreciated.
Thanks,
Boyd