Search results for query: *

I am trying to send a word document as an attachement but need to include a recipient as a "cc". I can use either macro but having trouble adding my "Cc:". Can someone help with this? Options.SendMailAttach = True ActiveDocument.SendMail or Private Sub CommandButton1_Click()...

I want to automatically save an updated excel worksheet to a particular folder on a network drive. I tried using the SaveAs method but I cannot seem to get my path to work. Can someone please help me with the code to save a document with the path name so each individual does not have to do a...

I am trying to count the number of unique values in a column. The column format is "general". The array is named "POLICY". I tried using {=sum(1/countif(policy,??))} but I don't know what the put after POLICY? I have a column that shows account numbers 11-11-1111-1 and there are duplicates...

I have a form created in word that will be emailed to a group of people for them to complete. Part of this same data is already in an access database (name, address, etc). Is there a way to pull in the data from access and automatically update the fields on my word form? I tried using the...

Perfect!!! Thank you so much!

I am having problems with my MsgBox code. I wanted the vbOKCancel button but then changed to vbOK. It still shows vbOKCancel but when I click either button, neither one works. When click OK continue running report; Cancel = back to form. This is what I have so far. I inserted the Msg coding...

Thanks vbajock & bandclar! I had a little trouble with the TransferSpreadSheet macro when it came to Table Name. I've never used this before, so I'm sure it is due to my lack of knowledge. I ended up just exporting report to excel and user can save report on their machine if needed. Dim...

I am trying to find the code that will save an Access Report automatically as an excel document. I am using Access 2000 with Windows XP. I am trying to add a command button on my form that will export an already created query or report as an excel document. I found the CreateNewDocument Method...

Forgive me for duplicating this, but I replied to my own thread. I am needing help with the following: See post on 4/14/04 (Posted 3/27/2004. I want to use the VLookup function in Excel to pull data from an Access database. I am using Excel 2000 in XP. Thank you!

Thanks for the reply, but I am still having difficulty with this method. Everytime I try this, it keeps trying to import the data into excel. It won't fit into excel due to exceeding the 65535 limit. I'm not quit following the 2nd paragraph: I did a new query and selected the data I wanted...

I am using Excel 2000 in XP. My excel worksheet has over 65535 records and will not be able to use Vlookup from another worksheet. If I have the same information in an Access database, can I pull the information (vlookup) from Access into my excel form? Basically, I enter a number into my...