I gang

VBA or VB to print addresses on postcard(s)

The purpose of this program is to take contact information from excel and produce an address label that will automatically be placed digitally on a postcard. We would like someone to use Excel VBA or a VisualBasic application to create a program that allows us to select a spreadsheet that contains contact information to import. The program you write should add the following features to the excel sheet:

• Print buttons in the last column of the excel sheet (column K in the attached reference sheet)

• When the button is pressed, it should take the address information from the excel row and format it as a label (shown in Label [url removed, login to view])

• This formatted label should be placed on a postcard PDF file with dimensions 8.5x5.5 inches LANDSCAPE about 2 inches from the bottom and 1 inch from the right side.

• It should then use the computer's default printer to print the label.

• Once the print button is pressed, the date should also be automatically added to the column preceding the print column (column J in the attached reference sheet)

• PLEASE use the attached excel spreadsheet for reference.

• If the program is used multiple times on the same excel sheet, it should first check if it has previously been used in order to ensure more print columns aren't created accidentally.

We need this automation to work consistently and efficiently.

Færdigheder: Visual Basic

Se mere: buttons 1 inch, 1 inch buttons, vba right, right vba, print vba, excel vba or, write to an excel sheet from pdf, vba excel pdf, postcard, Excel and VBA, excel png, vba print pdf file, pdf png php, application vba, vba architecture, import pdf vba, excel vba print, addresses pdf excel, excel add png, excel vba spreadsheet, add print, automation excel spreadsheet, excel print sheet, php pdf png, vba sheet

Om arbejdsgiveren:
( 280 bedømmelser ) New York, United States

Projekt-ID: #6033553

Tildelt til:

danielrinf

.............................................................................................................................................................................

$40 USD in 3 dage
(1 bedømmelse)
1.2

3 freelancere byder i gennemsnit $50 for dette job

zExcel

Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

$55 USD in 0 dage
(30 bedømmelser)
5.4
diegogarcia0531

Hi, I can do the job, just message me for further details. I am excel vba expert Regards Diego

$54 USD på 1 dag
(16 bedømmelser)
4.7