asked on

How to save a word 'form' (2010) before attaching to the new email (outlook 2010)

I had this question after viewing Word 2010/VBA: How to email Word doc as attachment and insert body text?.

Firstly, I am a relative VBA newby, so please forgive my ingnorace :)
I send different users a 'survey' form created in word 2010 with fillable fields.
I have used the above vba code to make it easy for the users to send the survey back, however it doesn't retain their entries. I have tried adding the line
ActiveDocument.Save
This works fine for me, but when the recipients click on the submit button, it comes up with the Save As box and even when they save, it will give them an error.
should I be using something like
ActiveDocument.SaveAs2 FileName:="H:\Completed Questionnaire.docx", _
FileFormat:=wdFormatDocumentDefault

and are there other components I should include?
save-sendvba.txt

Bill Prew

Are they just opening the attachment right from their email client? If so, have them save a copy to their local drive first, then open and edit that before using your macro.

»bp

Nick Vorhandern

ASKER

Opening from the original email message we send them. we wanted to simplify their task by having them:
a) open the word doc from the email we send them
b) answer the questions in the form
c) click a 'submit' button which saves and sends the doc back as an attachment

ASKER CERTIFIED SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nick Vorhandern

ASKER

That could be the issue. So it would be better to have a 'start survey' button which saves doc then the send button.
Thanks for your help 😎