Search results

And to connect via VBA: Shell "cmd.exe /k net use P: " & Chr(34) & "https://xxxxx610.sharepoint.com/Shared Documents/Lab/" & Chr(34), 0

I have tried to ignore the websites advising how to link, and found that I can but it is counter intuitive. To map the drive, one has to not use the second part of the wizard, i.e., "Connect to a website that you can store your documents and pictures". One inputs the url in the 'folder' option...

I did check whether my WebClient was running

Great question! I tried again but am unable to. I even followed advice from :/2017/01/20/how-to-map-your-sharepoint-online-library-like-a-network-drive/ (i am not allowed to post links!) To no avail. Tried shortening to https: //xxxxx610.sharepoint. /Shared[/Documents/Forms/AllItems.aspx...

Hi all, Hope someone can help - I have exhausted looking for a solution! At present my Database creates a pdf report from a result and saves it to a OneDrive directory, which uploads the file into Sharepoint. I would like to save the file directly to Sharepoint but have not fathomed out how...

Am I correct in the assumption that not all users are able to receive html email messages and hence better to rather use non-html emails to clients?

I see, thanks so much for your guidance. Was counter-intuitive to me It is a pity - would have been the best solution for my need. But have rethought this approach and have found a potential work around which is simply to use Replace() and swop out specific 'markers' for the code required...

Thanks for your further help, much appreciated. I have uploaded a database which when opens, shows a form with two buttons. The one called Variable, loads the string associated with a variable into the text window - showing the formatting without the code. The second button called Compose...

Thanks for your help! This is the calling code: Call GetResponse(ResponseID, Subject, Body) ResponseID = 1 This is the function: Function GetResponse(ResponseID As Integer, Subject As String, Body As String) Dim StmtResponse As String Dim rsResponse As Recordset StmtResponse = "SELECT * FROM...

Hi Colin, Thanks for your further input. The database does work sending emails correctly (thankfully!) The database uses around 10 pre-formatted different messages sent to clients. Essentially the reason I wanted to store these pre-formatted messages in a table is so that it would be easy to...

Thanks so much for your quick response. I do sort of build the code dynamically, but was hoping to store large parts in a table, e.g., "Dear " & [Customer_Name] & vbCrLf & vbCrLf & "Kindly send a Purchase Order document for the following samples received on " & [Order_received] & ":" &...

I am lost solving what should be a simple problem. I have the following coding: sbody = "Dear Customer" & vbCrLf & vbCrLf & _ "Kindly send a Purchase Order for the following" A debug.print shows: Dear Customer Kindly send a Purchase Order document for the following However when...

Hi, I am a new member. I have been programming in Microsoft Access for a number of years, but would place my skills at an 'average' level. I am grateful for forums like this one that has posts from experts that have helped solve other programmers problems, and from those I have learnt and...