How Proposal Pack Wizard integrates with Salesforce.com — step‑by‑step
-
Prerequisites
- Microsoft Word (desktop) installed.
- Active Salesforce.com account with API access.
- Proposal Pack Wizard (Salesforce edition) installed on the Windows machine.
- Internet connection and Salesforce credentials.
-
Install the add‑in
- Run the Proposal Pack Wizard Salesforce installer (.exe) and follow prompts.
- Restart Word if required; the wizard appears as a Word add‑in/ribbon.
-
Connect to Salesforce
- Open the Proposal Pack Wizard panel in Word.
- Choose “Connect to Salesforce” (or similar) and enter your Salesforce username/password and security token.
- Authorize the add‑in to access your Salesforce org (OAuth/login flow or API credentials).
-
Map Salesforce objects to templates
- In the wizard, select which Salesforce object you’ll pull data from (Opportunity, Account, Contact, Lead).
- Map Salesforce fields to template placeholders (e.g., {!Account.Name} → [ClientName] in Word template).
- Save mappings as a profile for reuse.
-
Select or create a proposal template
- Pick a built‑in Proposal Pack template or open a custom Word template.
- Insert merge fields/placeholders matching the mapping names.
- Configure sections (cover, scope, pricing tables, terms) and any conditional content.
-
Pull data and preview
- From the wizard choose an existing Salesforce record (search or paste record ID).
- Click “Import” or “Populate” to pull data into the template.
- Review the populated draft inside Word; fix formatting or mapping issues.
-
Customize dynamic content (optional)
- Use the wizard’s UI to add product line‑items, pricing tables, or repeatable sections populated from related Salesforce child records (e.g., OpportunityLineItems).
- Configure conditional blocks (include/exclude sections based on field values).
-
Generate and export
- Generate the final proposal as Word or PDF from the wizard.
- Save locally or attach back to Salesforce (Opportunity/Account/Contact) via the wizard’s “Save to Salesforce” or “Attach Document” function.
-
Save metadata and tracking
- When attaching, set title, description, and target Salesforce object.
- Optionally create a custom Proposal record or update Opportunity fields (status, last proposal date).
- Some installs allow versioning and storing the generated file in Salesforce Files or Notes & Attachments.
-
Automate (optional)
- Create a custom button/link in Salesforce that opens Proposal Pack Wizard (or triggers proposal generation via a flow/URL).
- Use saved mappings/templates so sales users can create proposals with one click from an Opportunity page.
- Test and train
- Test with sample records (Account, Opportunity, Line Items).
- Train users on selecting templates, running the connector, and attaching proposals back to Salesforce.
Common troubleshooting
- Login errors: verify security token and API access.
- Missing fields: ensure field-level security and the fields are included in the object layout or API.
- Repeated sections not populating: confirm child object mappings (OpportunityLineItems) are configured.
- Formatting issues: adjust Word template styles and reinsert merge placeholders.
If you want, I can provide a short checklist you can use when configuring the connector in your Salesforce org.
Leave a Reply