Recent content by MyerK

I'm attempting to manipulate an excel spreadsheet from within Access (add worksheet, move worksheet, rename worksheet, alter cells, save, etc). Quite often when I open the spreadsheet from within Excel to see if I was successful in programming from Access, I get a message that the spreadsheet...

Thanks a lot. MK

I remember reading that there is a property that can be set when you open a spreadsheet that suppresses user qustions such as 'Do you want to save?'. Don't remember what it is. Anybody remember? Thanks

I have a program that reads an Access database and write email Contacts to Outlook. Unfortunately there are about 9,000 names. This takes at least 30 minutes to write. Since Outlook displays the names in alphabetical there must be some type on indexing taking place during writing the contacts...

I'm attempting to do some programming from MS Access to Outlook or Outlook Express. Can anybody explain to me the difference between local contacts (or address books) in either? If both are installed on the same computer, do they share the same Contacts and Address Book or are they separate...

This wasn't a programming issue. If the user goes to File, Folders, Properties there's a property that when checked allows the folder to appear in the address book. Now of course I would like to be able to set this programatically. I'm using Outlook 2000. From what I've been able to find out...

Is there a Folder property in Outlook 2000 that is the equivalent of Shos asOutlookAB. I am creating a folder, populating it with contacts and I would like it to appear as an address book folder when creating email messages. Thanks.

Never mind. Done.

This is odd. Programatically I've figured out how to add contacts to the contacts folder. I' ve figured out how to add a sub-folder withing the vontacts folder. I moved contacts from the root folder to the new sub-folder. Now the problem. When I go into Outlook and create a new email...

I am attempting to write code in MSAccess to do the following in Outlook. I've been able to write contacts to the default contact folder (Code1). I've been able to create a new folder within the contacts folder (Code2). What I cannot figure out how to do is create the contact items in the...

I'm using MSAccess 2k and Outlook. I have been able to write (and/or delete) contacts from Access to Outlook. The end result is that I would like to have all of the newly added contacts placed in one Distribution List for email purposes. The emails will eventually be sent using Outlook so...

I am using MSAccess 2000 and Acrobat 6.0 I have several reports using the 'Adobe PDF' printer. I added a port to print the pdf files to a scecific directory. I have set Adobe PDF settings: View Adobe PDF results - Off Prompt for Adobe PDF file name - Off Ask to replace existing...

I am using MSAccess 2000 and Acrobat 6.0 I have several reports using the 'Adobe PDF' printer. I added a port to print the pdf files to a scecific directory. I have set Adobe PDF settings: View Adobe PDF results - Off Prompt for Adobe PDF file name - Off Ask to replace existing...

Why not 'Open' AvDOC and 'PrintPages' or 'PrintPagesSilent'? I haven't play with AvDOC yet but I've started using PDDoc. A bit of a pain getting info since Adobe is pricing documentation under the guise of ASN.

For learning purposes I am looking for some VBA (VB) programming examples using some of the CAcroPDDOC functions. I have used a few such as Open, Save, InsertPages, DeletePages, GetNumPages. The ones I am specifically interested in are AcquirePage, Create, ReplacePages, MovePage and any...