Search results

Thanks for the reply. Only just noticed it. I gave up in the end and my colleagues are just going to have to settle with pressing "save & send" themselves on the excel files. It works perfectly for word though. Thanks again for the suggestions,

I know this is a 12 year old post but i have been stressed to bits trying to work this out for months and stumbled across this today. THANK YOU! Works perfectly.

Hi! I have found this forum so helpful in the past so I am hoping that this is the place to get help for my new issue too. I have the code below which takes information from a form on access and sends it over to the correct place on an excel spreadsheet template. This works fine but I then...

Hi. Please can you advise what is wrong with this code? It works as far as the data from access is taken over to excel and then the save box will come up - the issue is that I want to to automatically save this as a file name, open up outlook, attach it to an e-mail and send it. Please let...

Thanks for all of your help - i have bookmarked the site you sent for future reference. I managed to work it out using the below code instead though: it might be helpful if anyone else comes across this thread. Private Sub Command154_Click() On Error Resume Next 'Declare the follwing...

Thank you. So for word i use the following... Dim objWord As Word.Application 'Set word as an application and make it invisible Set objWord = CreateObject("Word.Application") objWord.Visible = False 'True is visible 'path and name of the template...

I would like to update the template cells. I will then save it as a different file name and send using outlook but I already have that code working for word so will just (I think) be able to tweak that and adapt it to the excel form using active document coding etc. So really just asking for...

Hi. I have tried searching on the forum before posting but can't seem to find this (maybe because it is probably very easy). I have info on my access form which is located here.... Forms![Front Page]![Site 2 Owner] and here Forms![Front Page]![Postcode S2] I would like to export...

That works great. I knew it would be something along these lines but I am not quite there yet to work these things out. Thanks very much

I have deleted the additional code from the above post as it did make it look like there were issues with it when there aren't. I hope the above is clearer now.

Hi. All I want to do is save the file name as a variable. Everything works with the above code. Currently it saves at o2test.doc but I would like to name it the piece of text linked to a field the form on access. This text will be different depending on what info users enter. I added the...

Hi. I have also posted this in the "reports" section as I wasn't sure where it would go. I have looked around on the threads and don't seem to be able to find the answer. I currently have a working model which opens up a word document template, fills the bookmarks with info from...

Hi. I currently have a working model which opens up a word document template, fills the bookmarks with info from access, saves the file as a preset name and then send the document on Outlook. What I would like to do is save the document as a variable, preferably as something like " Climbing...

Hi. I have done it. i used the following code " Dim acc_req As String " then "acc_req = "O2 Access request" & " " & [Forms]![Front Page]![Text98].Value & " " & Forms![Front Page]![Site 2 Name].Value" then in the "outmail" .Subject = acc_req I still have another issue but think i...

Thank you very much for replying. The majority of this works well but I am stumped with the subject field. If i need the subject to be just the start date (contained on the document as a bookmark) how do I do that. So for example the word bookmark and the access field location are on the...

Hi. I have been working on a project for 3 months now and i am really close to completion but this last but is a real sticking point. As you'll see in the code below i have the code to fill in bookmarks on word using data from my access database, the "activedocument.sendmail" line only allows...