November 6th, 2003, 09:48 AM
|
|
Junior Member
|
|
Join Date: Nov 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Struggling with a Macro / VB
Hi,
I have a worksheet (Excel 2000) which is basically linked to an MS Access DB to extract customer information.
Other Worksheets within the workbook contain cost information so I cannot email the whole file to our customer.
What I am trying to do is have a field in the worksheet which contains the customer email address and a field which contains the quote number.
When I click a macro button I want the file to print to our PDF995 printer driver and save as the quote number then attach to a mail to go to the customer email address.
Is this possible?
Any help greatly appreciated. Pulling my hair out with this one. 
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
