Question about Microsoft Excel for PC

1 Answer

Data source connection

Hi,

I am trying to create a mail merge from the contents of an excel database with a built in user form. Have got the fields sorted for the merge, have got the form feeding the database, which connects to the merge, and everything works fine when i test it.

I have set up a button in excel which opens the userform, and a button on the userform which opens the merge, but i can't get the merge to automatically link up with the open database. Any ideas out there would be gratefully received!

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Wtwetewt

Posted on Oct 11, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

NEED TO KNOW HOW TO PRINT MORE THAN 1 ENVELOPE AT A TIME. DO LETTERS AND ENVELOPES ONCE A WEEK BUT THE PRINTER WOULD ONLY PROCESS 1 ENVELOPE AT A TIME AND I HAD TO DO THAT ONE MANUALLY.


Hi there !

For printing bulky letters or documents of the same format, I suggest you use the MS word mail merge document. You need to set up the mail merge document and the data of the file. For examples, the list of names, addresses telephone numbers and others should be input to the envelops.

Here's how to create mail merge document file.


1. Open a new blank MS word document or if you have a format already in a MS word format, just use it as default letter.

2. Go to menu bars (Home, Insert, Page Layout, References, Mailing, Review and View) and choose Mailing.

3. From Mailing, click on select recipients, choose use existing lists and find the excel document files that stores all the information like list of customers, company names, addresses, telephone numbers and others.

4. Open it and select table will appear and just click ok to merge it automatically to your default envelope.

5. Now you need to set up or format your envelope. from the Mailing menu, Insert Mail Merge Field will appear and click it to display the headings of your data source. Put the headings wherever you want.

6. After that, press preview result to display the datas. Save your work and it is finished

7

Jan 06, 2011 | Lexmark X 546dtn AllInOne Laser Printer

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

Unable to complete merge process.


Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

At what stage are you failing in the merge now?

May 15, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Validating in jsp


JavaScript Form Validation JavaScript can be used to validate input data in HTML forms before sending off the content to a server.
Form data that typically are checked by a JavaScript could be:
  • has the user left required fields empty?
  • has the user entered a valid e-mail address?
  • has the user entered a valid date?
  • has the user entered text in a numeric field?
Required Fields The function below checks if a required field has been left empty. If the required field is blank, an alert box alerts a message and the function returns false. If a value is entered, the function returns true (means that data is OK):
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{
alert(alerttxt);return false;
}
else
{
return true;
}
}
} The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{alert(alerttxt);return false;}
else {return true}
}
} function validate_form(thisform)
{
with (thisform)
{
if (validate_required(email,"Email must be filled out!")==false)
{email.focus();return false;}
}
}
</script>
</head> <body>
<form action="submitpage.htm"
onsubmit="return validate_form(this)"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>
</body> </html>
E-mail Validation The function below checks if the content has the general syntax of an email.
This means that the input data must contain at least an @ sign and a dot (.). Also, the @ must not be the first character of the email address, and the last dot must at least be one character after the @ sign:
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
} The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
} function validate_form(thisform)
{
with (thisform)
{
if (validate_email(email,"Not a valid e-mail address!")==false)
{email.focus();return false;}
}
}
</script>
</head> <body>
<form action="submitpage.htm"
onsubmit="return validate_form(this);"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>
</body> </html>


P.S.: If this information was helpful, please rate this solution.

Mar 13, 2009 | Sun Java Programming Language (cdj-275)

2 Answers

Mail Merge won't print


AppleWorks is a quirky and hopelessly outdated product. I am aware that a few people have an extreme fondness for it however.
It should only have taken minutes to import data, but don't do it in AppleWorks - they stopped making it years ago and it is unsupported and non-standard.
I have just taken two AppleWorks databases, - one older and one newer that needed to be combined. I exported them as tab delimited text and then imported them into Excel (You could use Apple Numbers - the modern equivalent to AppleWorks). Because the to db's had different headers, I imported them into two different Excel docs first and moved the columns around so the matched first, them copy each column over to the 'master' excel sheet.
You can either use the basic database tools in Excel, or once your data is combined and in this kind of data form, it is easy to import a .xls, or .csv into a new database program, such as Filemaker.
If you do copy over the data to Excel, any merge function - for label printing etc. has to be done in Word (or at least up to Word 2004). I was thrown by this until I realised you have to do this. Once a merge doc is set up with the right labels, it worked beautifully. Typical MS though it is a wholly unintuitive process.
Copy and importing data should be done with attention to care obviously. Make sure you have your original AW files backed up before you start.

May 20, 2008 | AppleWorks 6 for mac

4 Answers

How to create mailing labels in Microsoft Works


With a Microsoft Works Word document open, select: Tools>Labels>(the list of available label types will pop up, select the label sheet you're using) then select: Tools>Mail Merge>Open Data Source...

Don't know how it could be simpler.

Dec 18, 2007 | Microsoft Works 8.0 for PC

1 Answer

Labeling from exel


If you follow the Mail Merge instructions built into Microsoft Word's Mail Merge Wizard, you can use your Excel file as the data source for your Mail Merge document, which can be created using label templates built into Word or downloaded from the label manufacturer's website. If you need more detailed instructions, please let us know what version of Microsoft Office you're using, as well as the Operating System (PC or Mac, Windows '98, XP, Vista, Leopard, etc.) and the label manufacturer and label name and product number. Please let us know if you need more help.

Dec 11, 2007 | Computers & Internet

1 Answer

Mail Merge Print Problem


Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

Dec 05, 2007 | Dell Latitude D800 Notebook

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

117 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18355 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...