Replies

Ok. How about this?

Is there a registry setting that can tell me what SYSTEM.MDW file it was using? Maybe it was on a network share so I need to hunt for it.

Thanks

Thanks for the reply. I had a feeling about the “legal” way.

Since I work for a big corp, they will have to suffer not having a backup… lol

Thanks again

Thnk you very much…
That worked!!!!

So simple.

Thanks.

I actually just needed the first part. I gathered the Single most current records and did a make-Table query.

Then I used that new table to update my MASTER list.

Thanks Hans!

Thanks Hans… this worked great….

nice to see the Totals on the form….

Excellent work….

I was able to make the updates and it tested great!!!!

Thanks Hans

I fixed it…

Basically, the XLS Data has to have a corresponding Name and Email Address:

So the “TargetList” with the Manager and Email HAS to have a Corresponding Excel File for it to work…

Thanks

I did something similar in that I set the cursor to a spot and ran the script to that cursor.

What you suggested got the same result.

It is having issues getting the email address from ManagerList.

So the script jumps from line 34 to Line 60 and the error code is produced.

Thanks

This is working GREAT!!!

However there is a problem with this line:
‘ Look up e-mail address
strEmail = DLookup(“Email”, “ManagerList”, _
“[Manager]=” & Chr(34) & strName & Chr(34))
When I run it, I get an error “Invalid Use of Null”

If I take it out, it creates 700 emails in draft, but the Email Address is missing…

I created a “test” table called ManagerList and it has 2 Fields {Manager} and {Email}

What is the error pointing to???

Thanks
Leonard

Is the manager name stored in the ManagerList table as one field containing “Last First”, or as separate LastName and FirstName fields?

One field: [First {space} Last]

THAT IS SO SWEET!!!!

So this worked FLAWLESSLY!!!!

I dont know where you guys are, but I’ll buy you a Starbucks, or Dunkin Donut card or send you some pizzas!!!!… seriously.. send me a email.

Here is the next part:
1. I have the 150 Excel files formated as First Last.xls
2. I use Outlook 2003 and I have access to a generic MailBox (Asset Inventory).

Step1: Lookup Manager’s Name in a table: “ManagerList” and Extract the Email Address
Step2: The FROM Field has to be active and the Exchange name: Asset Inventory must be selected.
Step3: The new Message now needs to open the corresrponding file from c:Excel%First Last%.xls and attach it.
Step4: Finally, the New email should be SAVED… We don’t want to send it automatically….

Thanks

That worked… Awesome:

Another dilema:

When I open it, my Macro Security is set to High so it is Disabled. No problem, I selected Medium, where it asks me to “trust” it.

How can I make this a “trusted” script to avoid the security issues? If I email this to 100 people, I will have to have them change the Security and I want to AVOID this…

Thanks

More detailed information:

5 Cols:

Serial Number | User Name | Location | Manager | Email |

The recordset I want to build is all the equipment serial numbers belonging to one Manager.

Once determined, I would like to take the first three columns and place it in a pre-programmed Excel sheet in the first three columns and starting at row 5 for example.
The excel sheet should then be saved as %managername%.xls

If I get this far, I can do the Emailing manually…

I will try it… Thanks HANS!!!!!

Thank yo… I will test