Hi everyone, I am trying to do somthing which I am sure is very simple but I am new to this so am probably taking a long way round!
I have an online form which outputs to a .csv file on submit (located in the same folder as the form). The confirmation page links to a mail merge word.doc, also placed in the same folder. The problem I am having is that the mail merge doc was created on my local PC and no matter what I try it keeps the local link to the .csv file i.e. C:/My Documents/website/form_results.csv
I need it to link to the .csv file which is updated on the submission of the form i.e. http://www.ianpow.x10.bz/home/public/form_results.csv that kind of thing.
I think this may need some VBA. Basically I am trying to create a wizard for users so they enter structured data and at the end get a nicely formatted word document where I have included other text, images and docs depending on the form options they select. I need this so they don't have to do anthing more than enter their data on the form.
Any help or suggestions on alternative ways to get the same result would be appreciated! I know HTML pretty well but am new to everything else...
I have an online form which outputs to a .csv file on submit (located in the same folder as the form). The confirmation page links to a mail merge word.doc, also placed in the same folder. The problem I am having is that the mail merge doc was created on my local PC and no matter what I try it keeps the local link to the .csv file i.e. C:/My Documents/website/form_results.csv
I need it to link to the .csv file which is updated on the submission of the form i.e. http://www.ianpow.x10.bz/home/public/form_results.csv that kind of thing.
I think this may need some VBA. Basically I am trying to create a wizard for users so they enter structured data and at the end get a nicely formatted word document where I have included other text, images and docs depending on the form options they select. I need this so they don't have to do anthing more than enter their data on the form.
Any help or suggestions on alternative ways to get the same result would be appreciated! I know HTML pretty well but am new to everything else...