Form Not Received by Recipient

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top