Recent content by arc3636

It does seem to be working when I assign the path to a string variable first! Dim path As String Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem) With objMail .BodyFormat = olFormatHTML .HTMLBody = "Please respond to the attached...

Thanks for your response. It does pull the attachment correctly when the path is fully hard coded. I wonder if my problem has something to do with the path being pulled from a list box...

I have a database that manages documentation (via links to a shared drive) related to claims. The user creates a claim and can then attach related documents (word, pdf, msg, etc) in the database. After selecting documents from a combo box, a button will attach those to an email with a summary of...

Looks like it's working. The first file I ran with 12,000 records took less than 1 minute. Thanks again for your help!

Thanks for the idea, I'll give that a shot today.

I am simplifying the dataset in this example. In the final version, I’ll also need to add the service type and provider the rate corresponds to (which will increase the amount of data). The file I have from the first provider has 1,000 rows and we expect to get 40-50 bids. The rates will...

I’ve included the script below. The goal is to turn a single record KS, MN - 1.75 Into multiple records (in this case 2) KS --------1.75 MN ------1.75 The data is loaded multiple times throughout the day and I’d like to get it reformatted into something we can use for creating reports. I’m...

I have a table that has multiple values in a field separated by commas (KS, MN, MO). I wrote a VB script that separates the values and inserts them into separate records in a new table. I’m calling the VB script from a query in MS Access that reads the records in the source table. This works...