Export single record to Word to print (1 Viewer)

[Lonemascot]

Hi all.

I would like to have a button (cmdPrintIntroLetter) on my Client Details form that takes the client name, address and company data of the record that I'm currently viewing and putting it into an address box in a Word document. I also want to make use of a personalised greeting.

e.g. when I contact a new customer and input their details into my form I want to then be able to send them an introductory letter (standard wording) from me with just the click of a button.

------------------------------------------------
FAO: FirstName LastName
CompanyName
Address1
Address2
Address3
Town
County
Postcode

Date (TODAY)

RE: Company Introduction - Rubber Roofing Services

Dear FirstName (or Sir/Madam if Null value)

Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah

Kind regards

Jon Hurrell
Supreme Leader Of Alpha Team Rubber Roofing
------------------------------------------------

I've been faffing around with concatenating my address fields into an address textbox in a report but I really don't like using a report to write a letter, it just feels wrong - on every level. Can you still do this when taking the info to Word?

I also want another button (cmdEmailBrochure) which opens an email template using the records email address and inserting the name of the client into the body of the email.

Can anyone tell me what I need to do to make the above happen?

Thanks ever so much

 

[mikejaytlabustro]

Create a Command\Action "Outputto" to export the Report in Word or PDF Format.