FuzzyBear9
Technical User
Hi,
I want to export data (using the 'analyze this' feature)from a query into Excel. The data is needed for mass e-mailer program under Lotus Notes R.5, but have encountered two problems:
1) When I export the hyperlink field to Excel, its properties are retained. The hyperlink field contains e-mail addresses starting with 'mailto:'. How can I modify my query to capture just the text?
Example
CHANGE: mailto:test@example.com (as hyperlink)
To: test@example.com (as text)
2) When I export the data to Excel, the field names are retained (obviously), but the mass e-mailer program requires different names from the ones used in my tables.
Example
Query results (field names): Email Client Firstname(s)
Mass e-mailer: SendTo Company FirstName
Is there an easy way to rename the fields on import to Excel? What I want to end up with is a command button on a form that runs the query and saves the data as an Excel file in the required format!
Any ideas? Thanks for listening.
I want to export data (using the 'analyze this' feature)from a query into Excel. The data is needed for mass e-mailer program under Lotus Notes R.5, but have encountered two problems:
1) When I export the hyperlink field to Excel, its properties are retained. The hyperlink field contains e-mail addresses starting with 'mailto:'. How can I modify my query to capture just the text?
Example
CHANGE: mailto:test@example.com (as hyperlink)
To: test@example.com (as text)
2) When I export the data to Excel, the field names are retained (obviously), but the mass e-mailer program requires different names from the ones used in my tables.
Example
Query results (field names): Email Client Firstname(s)
Mass e-mailer: SendTo Company FirstName
Is there an easy way to rename the fields on import to Excel? What I want to end up with is a command button on a form that runs the query and saves the data as an Excel file in the required format!
Any ideas? Thanks for listening.